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.