Whit Armstrong <armstrong.w...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
