pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsystem 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