O/S = Windows 10
PostgreSQL 9.2.10, compiled by Visual C++ build 1600, 32-bit
http://www.postgresql.org/docs/9.1/interactive/sql-createtable.html
and like_option is:
{ INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES | STORAGE | COMMENTS | ALL }
1. INCLUDING CONSTRAINTS does not bring over the Foreign Keys
Not a bug since the documentation states that the only additional constraints that are brought over are check constraints. Not Null constraints are always brought over.
"""
Not-null constraints are always copied to the new table. CHECK constraints will only be copied if INCLUDING CONSTRAINTS is specified; other types of constraints will never be copied. Also, no distinction is made between column constraints and table constraints — when constraints are requested, all check constraints are copied.
"""
2. INCLUDING ALL does not work and generates an ERROR;
For kicks does writing it out in long form work?
"""
INCLUDING ALL is an abbreviated form of INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES INCLUDING STORAGE INCLUDING COMMENTS.
"""
David J.
