On 10/2/19 1:48 PM, Martin Mueller wrote:
I created a primary key with the following commands Add id serial Add primary key (id) I cannot figure out from the documentation how to drop that column.
Drop it just like you added it: test=# alter table foobar add id serial; ALTER TABLE test=# alter table foobar add primary key(id); ALTER TABLE test=# alter table foobar drop id; ALTER TABLE -- Angular momentum makes the world go 'round.