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

Tom Lane, 19.01.2011 19:19:
>> SELECT table_schema
>> FROM information_schema.tables
>> WHERE table_name = 'your_table'
>> ;
>
> That's not going to work, at least not in the interesting case where you
> have more than one candidate table --- that SELECT will list all of 'em.
>

Ah, right. I was a buit too quick with my answer.

Regards
Thomas