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

On Jan 19, 2011, at 3:12 PM, DM wrote:

> one of the way to find out schema name is like below
>
> select * from pg_tables where tablename like '%xyz%';
>  schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
> ------------+-----------+------------+------------+------------+----------+-------------
> (0 rows)
>
> ~Deepak
>

That does not work if the user entered a 'view' in the sql box.

Also a table/view could be in several schemas...

Jerry