system tables - Mailing list pgsql-admin
From | s.chava@wcom.com (Srinivasa Rao Chava) |
---|---|
Subject | system tables |
Date | |
Msg-id | 66d229f1.0110161220.60a9c795@posting.google.com Whole thread Raw |
List | pgsql-admin |
Hi when I give \d command at psql prompt, it is displaying all the tables including pgadmin_tables etc in development database. But when I give the same command in production datbase , it is just showing the table that have been created, not any system tables( pgadmin tables or views). why it is happening like this. The development result set is: DEPG=# \d List of relations Name | Type | Owner ----------------------------+-------+--------- announce | table | develop announce_index | table | develop announce_manager | table | develop contact_groups | table | develop contacts_two | table | develop cust_realms | table | pldev events_calendar_two | table | develop extranet_bug | table | develop extranet_bug_notes | table | develop extranet_bug_number | table | develop extranet_bug_tasks | table | develop extranet_docs | table | develop extranet_groupfolderperms | table | develop extranet_ids | table | develop extranet_personfolderperms | table | develop extranet_section | table | develop extranet_section1 | table | pgsql nprivate_label | table | pldev personal_info | table | pldev pgadmin_checks | view | pgsql pgadmin_databases | view | pgsql pgadmin_desc | table | pgsql pgadmin_functions | view | pgsql pgadmin_groups | view | pgsql pgadmin_indexes | view | pgsql pgadmin_languages | view | pgsql pgadmin_param | table | pgsql pgadmin_rev_log | table | pgsql pgadmin_seq_cache | table | pgsql pgadmin_sequences | view | pgsql pgadmin_table_cache | table | pgsql pgadmin_tables | view | pgsql pgadmin_triggers | view | pgsql pgadmin_users | view | pgsql pgadmin_views | view | pgsql private_label | table | pldev ref_contact_type | table | pldev ref_sla | table | pldev ref_srv_type | table | pldev survey_answers | table | develop (40 rows) The production result is : pgprod=# \d List of relations Name | Type | Owner ----------------------------+-------+----------- cust_realms | table | plprod extranet_docs | table | extraprod extranet_groupfolderperms | table | extraprod extranet_ids | table | extraprod extranet_personfolderperms | table | extraprod extranet_section | table | extraprod private_label | table | plprod ref_sla | table | plprod ref_srv_type | table | plprod (9 rows) Thanks for any help in advance.
pgsql-admin by date: