Generating sql to capture fully qualified table names??? - Mailing list pgsql-general

Hello all,

I am using the query below to generate SQL code to grant access to objects -
how do I get this statement to PULL the fully qualified name
(schema.tablename)???

*****************
SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON '  || relname ||
        ' TO newuser;'
          FROM pg_class
 where relname !~ 'pg_*' AND relkind in ('r','v','S') ORDER BY relname;

*****************

Thanks...Michelle :confused:


--
View this message in context:
http://www.nabble.com/Generating-sql-to-capture-fully-qualified-table-names----tf4654460.html#a13298439
Sent from the PostgreSQL - general mailing list archive at Nabble.com.