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

[Thomas Kellerer]

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