Re: system tables

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(dot)chava(at)wcom(dot)com [SMTP:s(dot)chava(at)wcom(dot)com]
> Sent: Tuesday, October 16, 2001 9:20 PM
> To: pgsql-admin(at)postgresql(dot)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.