|
postgres=#
postgres=# -- Creating the books table
postgres=#
postgres=# CREATE TABLE books (
postgres(# id integer UNIQUE,
postgres(# title text NOT NULL,
postgres(# author_id integer,
postgres(# subject_id integer,
postgres(# CONSTRAINT books_id_pkey PRIMARY KEY (id));
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "books_id_pkey" for table "books"
CREATE TABLE
postgres=#
postgres=# \d books;
Table "public.books"
Column | Type | Modifiers
------------+---------+-----------
id | integer | not null
title | text | not null
author_id | integer |
subject_id | integer |
Indexes:
"books_id_pkey" PRIMARY KEY, btree (id)
postgres=#
postgres=# -- Adding a column
postgres=#
postgres=# ALTER TABLE books ADD publication date;
ALTER TABLE
postgres=#
postgres=#
postgres=# \d books;
Table "public.books"
Column | Type | Modifiers
-------------+---------+-----------
id | integer | not null
title | text | not null
author_id | integer |
subject_id | integer |
publication | date |
Indexes:
"books_id_pkey" PRIMARY KEY, btree (id)
postgres=#
postgres=# drop table books;
DROP TABLE
postgres=#
postgres=#
|