pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to view all database,tables,users
4+ messages / 4 participants
[nested] [flat]
* how to view all database,tables,users
@ 2007-05-23 08:53 Mondi Ravi <ravimondi@wlink.com.np>
2007-05-23 10:57 ` Re: how to view all database,tables,users Thomas Markus <t.markus@proventis.net>
2007-05-23 12:03 ` Re: how to view all database,tables,users Ireneusz Pluta <ipluta@wp.pl>
2007-05-24 06:38 ` Re: how to view all database,tables,users Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: Mondi Ravi @ 2007-05-23 08:53 UTC (permalink / raw)
To: pgsql-admin
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
yours sincerely
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to view all database,tables,users
2007-05-23 08:53 how to view all database,tables,users Mondi Ravi <ravimondi@wlink.com.np>
@ 2007-05-23 10:57 ` Thomas Markus <t.markus@proventis.net>
2 siblings, 0 replies; 4+ messages in thread
From: Thomas Markus @ 2007-05-23 10:57 UTC (permalink / raw)
To: pgsql-admin
use tables/views in scheme pg_catalog/information_schema
try
select * from pg_catalog.pg_database;
select * from pg_catalog.pg_user;
select * from pg_catalog.pg_tables;
Mondi Ravi schrieb:
> i can't find out command to show all databases,tables,users and
> integrity constraints relationships;
> yours sincerely
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
Attachments:
t.markus.vcf (text/x-vcard, 253B) download
begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t.markus@proventis.net
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to view all database,tables,users
2007-05-23 08:53 how to view all database,tables,users Mondi Ravi <ravimondi@wlink.com.np>
@ 2007-05-23 12:03 ` Ireneusz Pluta <ipluta@wp.pl>
2 siblings, 0 replies; 4+ messages in thread
From: Ireneusz Pluta @ 2007-05-23 12:03 UTC (permalink / raw)
To: Mondi Ravi <ravimondi@wlink.com.np>; +Cc: pgsql-admin
Mondi Ravi napisał(a):
> i can't find out command to show all databases,tables,users and
> integrity constraints relationships;
> yours sincerely
See tables and views of system catalogs:
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
and use just SELECT statements on them to get what want.
You may use some of:
http://www.postgresql.org/docs/8.2/interactive/functions-info.html
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html
functions in these statements.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to view all database,tables,users
2007-05-23 08:53 how to view all database,tables,users Mondi Ravi <ravimondi@wlink.com.np>
@ 2007-05-24 06:38 ` Vishal Arora <aroravishal22@hotmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Vishal Arora @ 2007-05-24 06:38 UTC (permalink / raw)
To: ravimondi@wlink.com.np; +Cc: pgsql-admin
Apart from select statements you can use the following commands on psql
prompt -
\d [NAME] describe table, index, sequence, or view
\d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
list tables/indexes/sequences/views/system tables
\da [PATTERN] list aggregate functions
\db [PATTERN] list tablespaces (add "+" for more detail)
\dc [PATTERN] list conversions
\dC list casts
\dd [PATTERN] show comment for object
\dD [PATTERN] list domains
\df [PATTERN] list functions (add "+" for more detail)
\dg [PATTERN] list groups
\dn [PATTERN] list schemas (add "+" for more detail)
\do [NAME] list operators
\dl list large objects, same as \lo_list
\dp [PATTERN] list table, view, and sequence access privileges
\dT [PATTERN] list data types (add "+" for more detail)
\du [PATTERN] list users
\l list all databases (add "+" for more detail)
\z [PATTERN] list table, view, and sequence access privileges (same as
\dp)
Hope this would answer your query.
>From: Mondi Ravi <ravimondi@wlink.com.np>
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] how to view all database,tables,users
>Date: Wed, 23 May 2007 14:38:58 +0545
>
>i can't find out command to show all databases,tables,users and
>integrity constraints relationships;
>yours sincerely
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
_________________________________________________________________
Like the way Microsoft Office Outlook works? Youll love Windows Live
Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_outlook_05...
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-05-24 06:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-23 08:53 how to view all database,tables,users Mondi Ravi <ravimondi@wlink.com.np>
2007-05-23 10:57 ` Thomas Markus <t.markus@proventis.net>
2007-05-23 12:03 ` Ireneusz Pluta <ipluta@wp.pl>
2007-05-24 06:38 ` Vishal Arora <aroravishal22@hotmail.com>
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