ALTER TABLE books RENAME COLUMN
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=# -- Renaming a column
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=#
postgres=# ALTER TABLE books RENAME COLUMN id TO table_id;
ALTER TABLE
postgres=#
postgres=# \d books
Table "public.books"
Column | Type | Modifiers
------------+---------+-----------
table_id | integer | not null
title | text | not null
author_id | integer |
subject_id | integer |
Indexes:
"books_id_pkey" PRIMARY KEY, btree (table_id)
postgres=#
postgres=#
postgres=# ALTER TABLE books RENAME table_id TO id;
ALTER 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=#
postgres=#
postgres=# drop table books;
DROP TABLE
Related examples in the same category