SET client_min_messages = WARNING;
CREATE SCHEMA import;
IMPORT FOREIGN SCHEMA "SCOTT" LIMIT TO ("typetest1") FROM SERVER oracle INTO import OPTIONS (case 'lower');
SELECT t.relname, fs.srvname, ft.ftoptions
FROM pg_foreign_table ft
     JOIN pg_class t ON ft.ftrelid = t.oid
     JOIN pg_foreign_server fs ON ft.ftserver = fs.oid
WHERE relnamespace = 'import'::regnamespace;
  relname  | srvname |           ftoptions            
-----------+---------+--------------------------------
 typetest1 | oracle  | {schema=SCOTT,table=TYPETEST1}
(1 row)

SELECT attname, atttypid::regtype, attfdwoptions
FROM pg_attribute
WHERE attrelid = 'typetest1'::regclass
  AND attnum > 0
  AND NOT attisdropped
ORDER BY attnum;
 attname |         atttypid         | attfdwoptions 
---------+--------------------------+---------------
 id      | integer                  | {key=yes}
 c       | character                | 
 nc      | character                | 
 vc      | character varying        | 
 nvc     | character varying        | 
 lc      | text                     | 
 r       | bytea                    | 
 u       | uuid                     | 
 lb      | bytea                    | 
 lr      | bytea                    | 
 b       | boolean                  | 
 num     | numeric                  | 
 fl      | double precision         | 
 db      | double precision         | 
 d       | date                     | 
 ts      | timestamp with time zone | 
 ids     | interval                 | 
 iym     | interval                 | 
(18 rows)