Re: Query to return schema/table/columname/columntype - Mailing list pgsql-sql

On Fri, Jan 19, 2007 at 12:41:19 +0000, paallen@attglobal.net 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.