Create tables in PostgreSQL
Published on 1/13/2009 by editor|
Vote this tutorial:
|
More articles in PostgreSQL
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.
Comments:no comments submitted


