On Tue, Aug 23, 2016 at 1:24 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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.