Create tables in PostgreSQL

Published on 1/13/2009 by editor

Creating tables in PostgreSQL simiar like other SQL databases. Following code creates an table:

CREATE TABLE weather (
city            varchar(80),
temp_lo         int,           -- low temperature
temp_hi         int,           -- high temperature
prcp            real,          -- precipitation
date            date
);

White space (i.e., spaces, tabs, and newlines) can be used freely in SQL commands.PostgreSQL supports the standard SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and a rich set of geometric types.

Latest Posts

• Create tables in PostgreSQL