Whit Armstrong <armstrong.whit@gmail.com> writes:
> However, there is no example that uses a schema + tablename.
If you're into masochism you can do that with a join of pg_class and
pg_namespace. But what's usually easier for one-off queries is to
use the regclass converter:
select attname, atttypid from pg_attribute
where attrelid = 'myschema.mytable'::regclass;
Most likely you'll also want
... and attnum > 0 and not attisdropped
to keep down the clutter.
regards, tom lane
