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

1. PostgreSQL
2. Table
3. Create 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=#
           
       

Related examples in the same category