Re: getting a list of users

On Fri, 2002-11-29 at 20:56, Adler, Stephen wrote:
> how do you get a list of users and what their permissions are.

SELECT * FROM pg_user;

Permissions granted on various objects are shown by \z inside psql.

> how do you get a list of databases.

From a Unix prompt: psql -l
Inside psql:        \l
              or:   SELECT * FROM pg_databases;

> how do you get a description of a table as you would with
>   the command 'describe table blaaa' in mysql.

\d blaaa
\d+ blaaa    will show comments, if any.


All the \x commands use fairly complicated SQL to do their jobs.  Start
psql with the -E option to see what they are actually doing.

> I've just started using postresql today. Thanks.

A good choice!

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Who shall ascend into the hill of the LORD? or who
      shall stand in his holy place? He that hath clean
      hands, and a pure heart..."            Psalms 24:3,4