Re: is there any difference DROP PRIMARY KEY in oracle and postgres?

John R Pierce <pierce@hogranch.com> writes:
> On 11/5/2015 11:25 PM, Thomas Kellerer wrote:
>> But having an "alter table drop primary key" would indeed be nice.

> is that syntax in the sql standard?   or is it just an oraclism?

AFAICS there is no such syntax in SQL:2011 --- it only offers
"ALTER TABLE name DROP CONSTRAINT name".

            regards, tom lane