-- CREATE FOREIGN TABLE

CREATE SCHEMA foreign_schema;

CREATE SERVERsc FOREIGN DATA WRAPPER dummy;

CREATE SERVERs0 FOREIGN DATA WRAPPER dummy;

CREATE FOREIGN TABLE ft1 (); -- ERROR

ERROR: syntax error at or near ";"

LINE 1: CREATE FOREIGN TABLE ft1 ();

^

CREATE FOREIGN TABLE ft1 () SERVER no_server; -- ERROR

ERROR: server "no_server" does not exist

CREATE FOREIGN TABLE ft1 (c1 serial) SERVERsc; -- ERROR

CREATE FOREIGN TABLE ft1 (c1 serial) SERVERs0; -- ERROR

NOTICE: CREATE FOREIGN TABLE will create implicit sequence "ft1_c1_seq" for serial column "ft1.c1"

ERROR: default values on foreign tables are not supported

CREATE FOREIGN TABLE ft1 () SERVERsc WITH OIDS; -- ERROR

CREATE FOREIGN TABLE ft1 () SERVERs0 WITH OIDS; -- ERROR

ERROR: syntax error at or near "WITH OIDS"

LINE 1: CREATE FOREIGN TABLE ft1 () SERVERsc WITH OIDS;

LINE 1: CREATE FOREIGN TABLE ft1 () SERVERs0 WITH OIDS;

^

CREATE FOREIGN TABLE ft1 (

c1 integer NOT NULL,

c2 text,

c3 date

) SERVERsc OPTIONS (delimiter ',', quote '"');

) SERVERs0 OPTIONS (delimiter ',', quote '"');

COMMENT ON FOREIGN TABLE ft1 IS 'ft1';

COMMENT ON COLUMN ft1.c1 IS 'ft1.c1';

\d+ ft1

c1 | integer | not null | plain | ft1.c1

c2 | text | | extended |

c3 | date | | plain |

Server:sc

Server:s0

Has OIDs: no

\det+

List of foreign tables

Schema | Table | Server | Options

--------+-------+--------+----------------------------

public | ft1 |sc | {"delimiter=,","quote=\""}

public | ft1 |s0 | {"delimiter=,","quote=\""}

(1 row)

CREATE INDEX id_ft1_c2 ON ft1 (c2); -- ERROR

c7 | integer |

c8 | text |

c10 | integer |

Server:sc

Server:s0

-- Information schema

SELECT * FROM information_schema.foreign_data_wrappers ORDER BY 1, 2;

SELECT * FROM information_schema.foreign_servers ORDER BY 1, 2;

foreign_server_catalog | foreign_server_name | foreign_data_wrapper_catalog | foreign_data_wrapper_name | foreign_server_type | foreign_server_version | authorization_identifier

------------------------+---------------------+------------------------------+---------------------------+---------------------+------------------------+--------------------------

regression | s0 | regression | dummy | | | foreign_data_user

regression | s4 | regression | foo | oracle | | foreign_data_user

regression | s5 | regression | foo | | 15.0 | regress_test_role

regression | s6 | regression | foo | | 16.0 | regress_test_indirect

regression | s8 | regression | postgresql | | | foreign_data_user

regression | sc | regression | dummy | | | foreign_data_user

regression | t1 | regression | foo | | | regress_test_indirect

regression | t2 | regression | foo | | | regress_test_role

(7 rows)

SELECT * FROM information_schema.foreign_tables ORDER BY 1, 2, 3;

foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name

-----------------------+----------------------+--------------------+------------------------+---------------------

regression | foreign_schema | foreign_table_1 | regression |sc

regression | foreign_schema | foreign_table_1 | regression |s0

(1 row)

SELECT * FROM information_schema.foreign_table_options ORDER BY 1, 2, 3, 4;

DROP ROLE regress_test_role2;

DROP FOREIGN DATA WRAPPER postgresql CASCADE;

DROP FOREIGN DATA WRAPPER dummy CASCADE;

NOTICE: drop cascades to serversc

NOTICE: drop cascades to servers0

\c

DROP ROLE foreign_data_user;

-- At this point we should have no wrappers, no servers, and no mappings.

CREATESCHEMAforeign_schema;

CREATE SERVERsc FOREIGN DATA WRAPPER dummy;

CREATE SERVERs0 FOREIGN DATA WRAPPER dummy;

CREATE FOREIGN TABLE ft1 ();-- ERROR

CREATE FOREIGN TABLE ft1 () SERVER no_server;-- ERROR

CREATE FOREIGN TABLE ft1 (c1serial) SERVERsc;-- ERROR

CREATE FOREIGN TABLE ft1 () SERVERsc WITH OIDS;-- ERROR

CREATE FOREIGN TABLE ft1 (c1serial) SERVERs0;-- ERROR

CREATE FOREIGN TABLE ft1 () SERVERs0 WITH OIDS;-- ERROR

CREATE FOREIGN TABLE ft1 (

c1integerNOT NULL,

c2text,

c3date

) SERVERsc OPTIONS (delimiter',', quote'"');

) SERVERs0 OPTIONS (delimiter',', quote'"');

COMMENTON FOREIGN TABLE ft1 IS'ft1';

COMMENT ON COLUMN ft1.c1 IS'ft1.c1';

\d+ ft1