Use ADD CONSTRAINT syntax to specify name of primary key

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

978 stars 341 forks source link

Use ADD CONSTRAINT syntax to specify name of primary key #1706

Closed marty-se closed 8 months ago

marty-se commented 8 months ago

ALTER TABLE tbl ADD PRIMARY KEY const_name (...) is not valid PostgreSQL syntax.