I am trying to use the export objects function to get the code to create a table. But when I run it, I don't get the code.
This is what I am doing
Code: Select all
dbadmin=> \dt default_data;
List of tables
Schema | Name | Kind | Owner | Comment
--------+--------------+-------+---------+---------
public | default_data | table | dbadmin |
(1 row)
dbadmin=> select export_objects('','default_data');
export_objects
---------------------------------------------------------------
CREATE SCHEMA default_data;
SELECT MARK_DESIGN_KSAFE(0);
(1 row)