I am trying to perform a query that will:
1. Return all user defined attributes from a relation.
2. Also return the datatypes of each relation.
So far I can only achieve part 1 with the following:
select attname from pg_class,pg_attribute
where relname=relation_name and
attrelid = pg_class.oid
Hi,
I need to find the query that will return all security access permissions.
For example if a INSERT has been granted to a particular user, how do I
perform the query which will return this result. I know that the \z command
returns this, but I need the raw SQL to do it - any ideas please?
