pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vishal Arora <aroravishal22@hotmail.com>
To: ravimondi@wlink.com.np
Cc: pgsql-admin@postgresql.org
Subject: Re: how to view all database,tables,users
Date: Thu, 24 May 2007 06:38:34 +0000
Message-ID: <BAY123-F1FAFAC31416B36435E6F8A9340@phx.gbl> (raw)
In-Reply-To: <1179910438.3908.2.camel@localhost.localdomain>

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...




view thread (4+ messages)

Message-ID: <BAY123-F1FAFAC31416B36435E6F8A9340@phx.gbl>
Permalink:  ../BAY123-F1FAFAC31416B36435E6F8A9340@phx.gbl/
Also on:    postgresql.org/message-id/BAY123-F1FAFAC31416B36435E6F8A9340@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: aroravishal22@hotmail.com, ravimondi@wlink.com.np
  Subject: Re: how to view all database,tables,users
  In-Reply-To: <BAY123-F1FAFAC31416B36435E6F8A9340@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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