Create A Table In Postgres

November - 2021

TODO: put in link to how to setup privilidges


login with:

psql -d database_name -U role_name

Example:

CREATE TABLE schema_name.new_table_name (
    code        char(5) CONSTRAINT firstkey PRIMARY KEY,
    title       varchar(40) NOT NULL,
    did         integer NOT NULL,
    date_prod   date,
    kind        varchar(10)
);