Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Retrieving User information




On Tue, 13 Jul 2004, Steven Bell wrote:

> What is the best method to retrieve user information on a particular 
> database?
> 

The JDBC DatabaseMetaData API has no provisions for returning a list of 
users.  It does have methods for permissions like getTablePrivileges, but 
this isn't the same.  You will likely need to issue direct sql statements 
against the system catalogs.  See pg_user for example.

Kris Jurka



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group