第1个回答 推荐于2016-08-05
TYPE
Here are the different type of export allowed, default is TABLE:
TABLE: Extract all tables with indexes, primary keys, unique keys, foreign keys and check constraints.
VIEW: Extract only views.
GRANT: Extract roles converted to Pg groups, users and grants on all objects.
SEQUENCE: Extract all sequence and their last position.
TABLESPACE: Extract storage space, need PostgreSQL >= v8.
TRIGGER: Extract triggers defined following actions.
FUNCTION: Extract functions.
PROCEDURES: Extract procedures.
PACKAGE: Extract packages and package bodies.
DATA: Extract datas as INSERT statement.
COPY: Extract datas as COPY statement.
PARTITION: Extract range and list partitioning.
TYPE: Extract Oracle user defined type.
FDW: Export Oracle tables as foreign table for oracle_fdw.
Only one type of export can be perform at the same time so the TYPE directive must be unique. If you have more than one only the last found in the configuration file will be registered.本回答被提问者采纳