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: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, October 16, 2001 9:20 PM > To: [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
