Introduction
-
Create a table
1234CREATE
TABLE
table_name (
column_name DOMAIN / TYPE [
COLLATE
...] column_constraint [
DEFAULT
...],
CONSTRAINT
constraint_name table_constraint
) INHERITS existing_table_name;
Example
12345678910111213141516171819202122232425CREATE
TABLE
public
.film
(
film_id
integer
NOT
NULL
DEFAULT
nextval(
'film_film_id_seq'
::regclass),
-- using a sequence generator with converting type to OID.
title
character
varying
(255)
COLLATE
pg_catalog.
"default"
NOT
NULL
,
description text
COLLATE
pg_catalog.
"default"
,
release_year
year
,
language_id
integer
NOT
NULL
,
rental_duration
smallint
NOT
NULL
DEFAULT
3,
rental_rate
numeric
(4,2)
NOT
NULL
DEFAULT
4.99,
length
smallint
,
replacement_cost
numeric
(5,2)
NOT
NULL
DEFAULT
19.99,
rating mpaa_rating
DEFAULT
'G'
::mpaa_rating,
last_update
timestamp
without
time
zone
NOT
NULL
DEFAULT
now(),
special_features text[]
COLLATE
pg_catalog.
"default"
,
fulltext tsvector
NOT
NULL
,
CONSTRAINT
film_pkey
PRIMARY
KEY
(film_id),
CONSTRAINT
film_language_id_fkey
FOREIGN
KEY
(language_id)
REFERENCES
public
.language (language_id) MATCH SIMPLE
ON
UPDATE
CASCADE
ON
DELETE
RESTRICT
)
WITH
(
OIDS =
FALSE
)
TABLESPACE pg_default;
-
Drop a table
1DROP
TABLE
public
.film;