On Fri, Jan 19, 2007 at 12:41:19 +0000, [EMAIL PROTECTED] wrote: > For background I am selecting table & schema by > the query: > SELECT schemaname || '.' || tablename AS tablename > FROM pg_tables ORDER BY tablename;
Are you guaranteed that all of the names are lower case? If not you may want to include quoting in your query. I didn't have a good answer for the base question you asked; this was more under the suggestions category. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly