Search Postgresql Archives

Re: Forward declaration of table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Aug 23, 2016 at 1:24 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

use ALTER TABLE ADD table_constraint :

https://www.postgresql.org/docs/9.5/static/sql-altertable.html

to add the FK references to word_games.


​Hadn't considered "ALTER TABLE" but I'd be afraid of dump-restore hazards here.  Maybe pg_dump is smart enough to handle this correctly, though - maybe by adding constraint definitions after all tables and columns are present.

David J.​


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux