Re: How can I find a schema that a table belong to?

Thomas Kellerer <spam_eater@xxxxxxx> · Wed, 19 Jan 2011 18:03:03 +0100



Jerry LeVan, 19.01.2011 17:35:

So I guess the question is:
    Given a bare table name, how can I recover the schema
    qualified name with whatever the current search path happens
    to be?


SELECT table_schema
FROM information_schema.tables
WHERE table_name = 'your_table'
;


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general