Re: how to view all database,tables,users

From: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
To: ravimondi(at)wlink(dot)com(dot)np
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to view all database,tables,users
Date: 2007-05-24 06:38:34
Message-ID: BAY123-F1FAFAC31416B36435E6F8A9340@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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

Hope this would answer your query.

>From: Mondi Ravi <ravimondi(at)wlink(dot)com(dot)np>
>To: pgsql-admin(at)postgresql(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Huxton 2007-05-24 06:41:55 Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.
Previous Message Vishal Arora 2007-05-24 06:31:35 Re: