pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: s.chava@wcom.com
To: pgsql-admin@postgresql.org
Subject: system tables
Date: 16 Oct 2001 13:20:16 -0700
Message-ID: <66d229f1.0110161220.60a9c795@posting.google.com> (raw)

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.



view thread (7+ messages)  latest in thread

Message-ID: <66d229f1.0110161220.60a9c795@posting.google.com>
Permalink:  ../66d229f1.0110161220.60a9c795@posting.google.com/
Also on:    postgresql.org/message-id/66d229f1.0110161220.60a9c795@posting.google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: s.chava@wcom.com
  Subject: Re: system tables
  In-Reply-To: <66d229f1.0110161220.60a9c795@posting.google.com>
  References: <66d229f1.0110161220.60a9c795@posting.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox