pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how 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? You’ll 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