Generating sql to capture fully qualified table names???

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.