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(dot)Elphick(at)lfix(dot)co(dot)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