Mega Code Archive

 

Categories / PostgreSQL / Table

 

Create a new table by specifying the table name, along with all column names and their types

postgres=# postgres=# -- Create a new table by specifying the table name, along with all column names and their types: postgres=# postgres=# CREATE TABLE weather ( postgres(#    city            varchar(80), postgres(#    temp_lo         int,           -- low temperature postgres(#    temp_hi         int,           -- high temperature postgres(#    prcp            real,          -- precipitation postgres(#    date            date postgres(# ); CREATE TABLE postgres=# postgres=# postgres=# drop table weather; DROP TABLE postgres=#