"Rob Burne" <[EMAIL PROTECTED]> writes:
> 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
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
