Generating sql to capture fully qualified table names???

[smiley2211 <smiley2211@xxxxxxxxx>]

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.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings