Re: system tables - Mailing list pgsql-admin

From Henshall, Stuart - WCP
Subject Re: system tables
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F746FE@MAIL_EXCHANGE
Whole thread Raw
In response to system tables  (s.chava@wcom.com (Srinivasa Rao Chava))
List pgsql-admin
pgadmin tables are not system tables; they're just used by the pgadmin tool.
I believe there is an option to clean them out somewhere in pgadmin.
System tables & views start with pg_
- Stuart


> -----Original Message-----
> From:    s.chava@wcom.com [SMTP:s.chava@wcom.com]
> Sent:    Tuesday, October 16, 2001 9:20 PM
> To:    pgsql-admin@postgresql.org
> Subject:    system tables
>
> 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:

Previous
From: Andrew Hill
Date:
Subject: Freeing Connections
Next
From: rnturn@baxter.com (Rick Turner)
Date:
Subject: Re: Database subdirectories in V7.1.x