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
