Whit Armstrong <armstrong.whit@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
