I'm testing on Windows 2008 64-bit pgAdmin 1.14.2 I used the odbc_fdw based foreign data table that I created with this statement:
CREATE FOREIGN TABLE my_tables (table_catalog character varying(128) , table_schema character varying(128) , table_name character varying(128) , table_type character varying(128) ) SERVER localsql2005 OPTIONS (database 'myserver2005', sql_query 'SELECT CAST(TABLE_CATALOG As varchar(128)) As table_catalog , CAST(TABLE_SCHEMA As varchar(128)) As table_schema, CAST(TABLE_NAME As varchar(128)) As table_name , CAST(TABLE_TYPE As varchar(128)) As table_type FROM information_schema.tables', sql_count 'select count(TABLE_NAME) from information_schema.tables'); When I use pgAdmin to regenerate the SQL ddl for it, it generates this malformed thing that can't be run: CREATE FOREIGN TABLE my_tables (table_catalog character varying(128) , table_schema character varying(128) , table_name character varying(128) , table_type character varying(128) ) SERVER localsql2005 OPTIONS (database 'myserver2005', sql_query 'SELECT CAST(TABLE_CATALOG As varchar(128)) As table_catalog , CAST(TABLE_SCHEMA As varchar(128)) As table_schema, CAST(TABLE_NAME As varchar(128)) As table_name , CAST(TABLE_TYPE As varchar(128)) As table_type FROM information_schema.tables', ,"sql_count 'select count(TABLE_NAME) from information_schema.tables"'); Thanks, Regina -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
