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