On Wed, 1 Dec 2010 12:30:46 +0900 Hitoshi Harada <umi.tan...@gmail.com> wrote: > This is another topic, but it would be useful if CREATE FOREIGN TABLE > can omit column definitions since fdw usually knows what should be > there in the definitions. I some times mistyped the column names > between remote and local and resulted in fail on execution.
The SQL/MED standard includes "IMPORT FOREIGN SCHEMA schema FROM SERVER server" syntax which imports definitions of remote tables in the specified schema into local PostgreSQL, and you can optionally specify the list of target tables with "LIMIT TO table_list" option. This syntax would make defining foreign tables easier, but it needs to enhance both FDW API and core parser. Regards, -- Shigeru Hanada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
