Altering column defaults : Add Column « Table « PostgreSQL






  1. PostgreSQL
  2. Table
  3. Add Column

Altering column defaults


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=#
postgres=# -- Altering column defaults
postgres=#
postgres=# ALTER TABLE books ALTER COLUMN id SET DEFAULT nextval('book_ids');
ERROR:  relation "book_ids" does not exist
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=# drop table books;
DROP TABLE
postgres=#








Related examples in the same category

1.ALTER TABLE employee ADD COLUMN description text
2.Add a new column with check option
3.Add a column
4.Adds a text column