Creating PostgreSQL Databases
Darryl Reeves
Industry Assistant Professor, New York University
CREATE TABLE book (
isbn CHAR(13) NOT NULL,
author_first_name VARCHAR(50) NOT NULL,
author_last_name VARCHAR(50) NOT NULL,
content TEXT NOT NULL
);
Text data types: TEXT
, VARCHAR(N)
, CHAR(N)
VARCHAR(N)
VARCHAR
without N specified equivalent to TEXT
first_name VARCHAR(50) NOT NULL;
CHAR(N)
values consist of exactly N charactersCHAR
equivalent to CHAR(1)
isbn CHAR(13) NOT NULL;
Creating PostgreSQL Databases