How to 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=#