PostgreSQL/Table/Table info

Use \d to display table information

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;