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