PostgreSQL notes

SQL

CREATE DATABASE database_name;

CREATE SCHEMA schema_name;

CREATE TABLE films (
    code        char(5) CONSTRAINT firstkey PRIMARY KEY,
    title       varchar(40) NOT NULL,
    did         integer NOT NULL,
    date_prod   date,
    kind        varchar(10),
    len         interval hour to minute
);

CREATE TABLE distributors (
     did    integer PRIMARY KEY DEFAULT nextval('serial'),
     name   varchar(40) NOT NULL CHECK (name <> '')
);

CREATE TABLE array_int (
    vector  int[][]
);

SELECT * FROM information_schema.tables 
WHERE table_schema = 'public'

ALTER TABLE