How to list all external tables in your schema

Note:\dx command list all external tables in your schema

[gpadmin@sachi ~]$ psql -d sachi

psql (8.2.15)

Type "help" for help.

sachi=# \dx

No relations found.

sachi=# \q

[gpadmin@sachi ~]$ psql -d gpperfmon

psql (8.2.15)

Type "help" for help.

gpperfmon=# \dx

List of relations

Schema | Name | Type | Owner | Storage

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

public | _database_tail | table | gpadmin | external

public | _diskspace_tail | table | gpadmin | external

public | _emcconnect_tail | table | gpadmin | external

public | _filerep_tail | table | gpadmin | external

public | _iterators_tail | table | gpadmin | external

public | _network_interface_tail | table | gpadmin | external

public | _queries_tail | table | gpadmin | external

public | _segment_tail | table | gpadmin | external

public | _socket_tail | table | gpadmin | external

public | _system_tail | table | gpadmin | external

public | _tcp_extended_tail | table | gpadmin | external

public | _tcp_tail | table | gpadmin | external

public | _udp_tail | table | gpadmin | external

public | database_now | table | gpadmin | external

public | database_tail | table | gpadmin | external

public | diskspace_now | table | gpadmin | external

public | diskspace_tail | table | gpadmin | external

public | filerep_now | table | gpadmin | external

public | filerep_tail | table | gpadmin | external

public | health_now | table | gpadmin | external

public | iterators_now | table | gpadmin | external

public | iterators_tail | table | gpadmin | external

public | master_data_dir | table | gpadmin | external

public | network_interface_now | table | gpadmin | external

public | network_interface_tail | table | gpadmin | external

public | queries_now | table | gpadmin | external

public | queries_now_fast | table | gpadmin | external

public | queries_tail | table | gpadmin | external

public | segment_now | table | gpadmin | external

public | segment_tail | table | gpadmin | external

public | socket_now | table | gpadmin | external

public | socket_tail | table | gpadmin | external

public | system_now | table | gpadmin | external

public | system_tail | table | gpadmin | external

public | tcp_extended_now | table | gpadmin | external

public | tcp_extended_tail | table | gpadmin | external

public | tcp_now | table | gpadmin | external

public | tcp_tail | table | gpadmin | external

public | udp_now | table | gpadmin | external

public | udp_tail | table | gpadmin | external

(40 rows)

gpperfmon=# \dt

List of relations

Schema | Name | Type | Owner | Storage

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

public | database_history | table | gpadmin | heap

public | database_history_1_prt_1 | table | gpadmin | heap

public | database_history_1_prt_r1079324718 | table | gpadmin | heap

public | database_history_1_prt_r1126781934 | table | gpadmin | heap

public | database_history_1_prt_r152416591 | table | gpadmin | heap

public | database_history_1_prt_r567447457 | table | gpadmin | heap

public | diskspace_history | table | gpadmin | heap

public | diskspace_history_1_prt_1 | table | gpadmin | heap

public | diskspace_history_1_prt_r1628211720 | table | gpadmin | heap

public | diskspace_history_1_prt_r1648171189 | table | gpadmin | heap

public | diskspace_history_1_prt_r331723798 | table | gpadmin | heap

public | diskspace_history_1_prt_r390156762 | table | gpadmin | heap

public | emcconnect_history | table | gpadmin | heap

public | emcconnect_history_1_prt_1 | table | gpadmin | heap

public | emcconnect_history_1_prt_r1601748427 | table | gpadmin | heap

public | emcconnect_history_1_prt_r1829124190 | table | gpadmin | heap

public | emcconnect_history_1_prt_r2135651735 | table | gpadmin | heap

public | emcconnect_history_1_prt_r215929265 | table | gpadmin | heap

public | filerep_history | table | gpadmin | heap

public | filerep_history_1_prt_1 | table | gpadmin | heap

public | filerep_history_1_prt_r179794136 | table | gpadmin | heap

public | filerep_history_1_prt_r1821055836 | table | gpadmin | heap

public | filerep_history_1_prt_r344823435 | table | gpadmin | heap

public | filerep_history_1_prt_r948218760 | table | gpadmin | heap

public | health_history | table | gpadmin | heap

public | health_history_1_prt_1 | table | gpadmin | heap

public | health_history_1_prt_r1282553706 | table | gpadmin | heap

public | health_history_1_prt_r1752537215 | table | gpadmin | heap

public | health_history_1_prt_r1890998944 | table | gpadmin | heap

public | health_history_1_prt_r913611475 | table | gpadmin | heap

public | iterators_history | table | gpadmin | heap

public | iterators_history_1_prt_1 | table | gpadmin | heap

public | iterators_history_1_prt_r1310901006 | table | gpadmin | heap

public | iterators_history_1_prt_r2007966402 | table | gpadmin | heap

public | iterators_history_1_prt_r266068560 | table | gpadmin | heap

public | iterators_history_1_prt_r644525 | table | gpadmin | heap

public | network_interface_history | table | gpadmin | heap

public | network_interface_history_1_prt_1 | table | gpadmin | heap

public | queries_history | table | gpadmin | heap

public | queries_history_1_prt_1 | table | gpadmin | heap

public | queries_history_1_prt_r142102942 | table | gpadmin | heap

public | queries_history_1_prt_r355351462 | table | gpadmin | heap

public | queries_history_1_prt_r435170993 | table | gpadmin | heap

public | queries_history_1_prt_r913038426 | table | gpadmin | heap

public | segment_history | table | gpadmin | heap

public | segment_history_1_prt_1 | table | gpadmin | heap

public | segment_history_1_prt_r153875602 | table | gpadmin | heap

public | segment_history_1_prt_r179606398 | table | gpadmin | heap

public | segment_history_1_prt_r2011560616 | table | gpadmin | heap

public | segment_history_1_prt_r2128585717 | table | gpadmin | heap

public | socket_history | table | gpadmin | heap

public | socket_history_1_prt_1 | table | gpadmin | heap

public | system_history | table | gpadmin | heap

public | system_history_1_prt_1 | table | gpadmin | heap

public | system_history_1_prt_r1156031827 | table | gpadmin | heap

public | system_history_1_prt_r1555829142 | table | gpadmin | heap

public | system_history_1_prt_r1812438527 | table | gpadmin | heap

public | system_history_1_prt_r570371466 | table | gpadmin | heap

public | tcp_extended_history | table | gpadmin | heap

public | tcp_extended_history_1_prt_1 | table | gpadmin | heap

public | tcp_history | table | gpadmin | heap

public | tcp_history_1_prt_1 | table | gpadmin | heap

public | udp_history | table | gpadmin | heap

public | udp_history_1_prt_1 | table | gpadmin | heap

(64 rows)

gpperfmon=#