On Wed, Jun 6, 2012 at 1:41 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > Inside a perl/dbi script, I want to determine which privs (select, insert, > update, delete, ...) user 'foo' has on table 'footable'. There must be > metadata tables or a view that has this. Try: psql -E dbname \z tablename And look at the query printed by psql. You should be able to adapt that to your needs. Josh -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
