From: | s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava) |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | system tables |
Date: | 2001-10-16 20:20:16 |
Message-ID: | 66d229f1.0110161220.60a9c795@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-10-16 22:14:21 | Re: Database subdirectories in V7.1.x |
Previous Message | Peter Eisentraut | 2001-10-16 20:14:55 | Re: tcl wish--simple configure problem |