Re: How can I find a schema that a table belong to? - Mailing list pgsql-general

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'
;