pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
system tables
7+ messages / 7 participants
[nested] [flat]

* system tables
@ 2001-10-16 20:20 Srinivasa Rao Chava <s.chava@wcom.com>
  0 siblings, 0 replies; 7+ messages in thread

From: s.chava@wcom.com @ 2001-10-16 20:20 UTC (permalink / raw)
  To: 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.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: system tables
@ 2001-10-18 09:57 Henshall, Stuart - WCP <SHenshall@westcountrypublications.co.uk>
  0 siblings, 0 replies; 7+ messages in thread

From: Henshall, Stuart - WCP @ 2001-10-18 09:57 UTC (permalink / raw)
  To: 's.chava@wcom.com' <s.chava@wcom.com>; 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.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* System Tables
@ 2003-08-25 10:23 Andrzej Schulz <andrzej.schulz@galileo.com.pl>
  2003-08-25 18:01 ` Re: System Tables Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 7+ messages in thread

From: Andrzej Schulz @ 2003-08-25 10:23 UTC (permalink / raw)
  To: pgsql-admin

Hi, I would Like to get information abort tables existing In PostgreSQL
via  PHP. I would like to know the names, their description and of
course how they are build.
I Am not quite sure how to get this on the Web Site, in PG I can use 
 
"\d table_name", but it doesn't work here
 
Can Someone help me?
 
I know that is very simple for You, but I am a newbie.
 
Thanks
 
Andrzej Schulz

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: System Tables
  2003-08-25 10:23 System Tables Andrzej Schulz <andrzej.schulz@galileo.com.pl>
@ 2003-08-25 18:01 ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 7+ messages in thread

From: Peter Eisentraut @ 2003-08-25 18:01 UTC (permalink / raw)
  To: Andrzej Schulz <andrzej.schulz@galileo.com.pl>; +Cc: pgsql-admin

Andrzej Schulz writes:

> Hi, I would Like to get information abort tables existing In PostgreSQL
> via  PHP. I would like to know the names, their description and of
> course how they are build.

http://www.postgresql.org/docs/7.3/static/catalogs.html

-- 
Peter Eisentraut   peter_e@gmx.net




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* System Tables
@ 2003-08-25 10:27 Jaskier <jaskierbard@poczta.onet.pl>
  2003-08-25 12:45 ` Re: System Tables maillist <maillist@tnss.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Jaskier @ 2003-08-25 10:27 UTC (permalink / raw)
  To: pgsql-admin

Hi, I would Like to get information abort tables existing In PostgreSQL
via  PHP. I would like to know the names, their description and of
course how they are build.
I Am not quite sure how to get this on the Web Site, in PG I can use 
 
"\d table_name", but it doesn't work here
 
Can Someone help me?
 
I know that is very simple for You, but I am a newbie.
 
Thanks
 
Andrzej Schulz

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: System Tables
  2003-08-25 10:27 System Tables Jaskier <jaskierbard@poczta.onet.pl>
@ 2003-08-25 12:45 ` maillist <maillist@tnss.com>
  0 siblings, 0 replies; 7+ messages in thread

From: maillist @ 2003-08-25 12:45 UTC (permalink / raw)
  To: Jaskier <jaskierbard@poczta.onet.pl>; +Cc: pgsql-admin

well in unix man psql command line options -E shows the queries that are
generated by the \d or other sudo commands

reading a 10 point font on a 1600x1280 screen sucks, please text only to
mailing lists
-- 
Arno Karner aka Behind the Muffs
West 7th St., St. Paul aka smell, Minn
http://tnss.com/noise_stink



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* System Tables
@ 2005-10-05 19:29 Adriano Gaspar <adrianogaspar@ibest.com.br>
  0 siblings, 0 replies; 7+ messages in thread

From: Adriano Gaspar @ 2005-10-05 19:29 UTC (permalink / raw)
  To: majrodomo@postgresql.org

I´m interesting in learning Postgre because I´m working with it now, if you can, i want to know wich are the system tables, and in wich of them can I find a table with all of the tables, and constrants.

Thanks,
Adriano Gaspar.

No iBest, suas horas navegadas valem pontos que podem ser trocados por prêmios. Sem sorteio! Inscreva-se já! www.navegueeganhe.com.br



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2005-10-05 19:29 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-16 20:20 system tables Srinivasa Rao Chava <s.chava@wcom.com>
2001-10-18 09:57 Re: system tables Henshall, Stuart - WCP <SHenshall@westcountrypublications.co.uk>
2003-08-25 10:23 System Tables Andrzej Schulz <andrzej.schulz@galileo.com.pl>
2003-08-25 18:01 ` Re: System Tables Peter Eisentraut <peter_e@gmx.net>
2003-08-25 10:27 System Tables Jaskier <jaskierbard@poczta.onet.pl>
2003-08-25 12:45 ` Re: System Tables maillist <maillist@tnss.com>
2005-10-05 19:29 System Tables Adriano Gaspar <adrianogaspar@ibest.com.br>

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