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