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=#
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=# CREATE TABLE new_books (id, title, author_id, subject_id)
postgres-# AS SELECT id, title, author_id, subject_id FROM books;
SELECT
postgres=#
postgres=# ALTER TABLE books RENAME TO old_books;
ALTER TABLE
postgres=#
postgres=# ALTER TABLE new_books RENAME TO books;
ALTER TABLE
postgres=#
postgres=# \d new_books
Did not find any relation named "new_books".
postgres=#
postgres=#
postgres=# \d books
Table "public.books"
Column | Type | Modifiers
------------+---------+-----------
id | integer |
title | text |
author_id | integer |
subject_id | integer |
postgres=#
postgres=#
postgres=# DROP TABLE books;
DROP TABLE
postgres=# DROP TABLE old_books;