On 17/01/2012 12:58, Tefft, Michael J wrote: > Any suggestions for doing this from PL/pgSQL? If you run psql with the -E option, and then do various \d commands to examine database objects, it will output the queries it generates to get metadata - you can then adapt these to your own needs. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general