Postgres detach a primary key from a sequence

Question

how can i detach a primary key of table from a sequence with out having to drop the table

Programmatically, or with an admin utility?

Lynn Crumbling
– Lynn Crumbling

2015-04-30 13:10:10 +00:00
Commented Apr 30, 2015 at 13:10 — Lynn Crumbling
– Lynn Crumbling, Commented Apr 30, 2015 at 13:10

Tom-db · Accepted Answer · 2019-05-08 09:39:34Z

5

With "detach" you mean probably, removing the default for the column to the next value of the sequence. For example, say you have a table definition like this:

 Column   |  Type   |                           Modifiers                            
------------+---------+----------------------------------------------------------------
 yourcolumn | integer | not null default nextval('yourtable_yourcolumn_seq'::regclass)

you want to remove this part: default nextval('yourtable_yourcolumn_seq'::regclass)

If so, you can do it with this statement:

ALTER TABLE yourtable ALTER COLUMN yourcolumn DROP DEFAULT;

edited May 8, 2019 at 9:39

answered Apr 30, 2015 at 13:14

Tom-db

6,9584 gold badges33 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mekbib.awoke Over a year ago

Thank you, that was what I was looking for, an ALTER query.

Collectives™ on Stack Overflow

Postgres detach a primary key from a sequence

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related