On 7/20/2017 11:11 PM, Nikhil wrote:
Schema = tenant. So basically tenant level logging.
select .... from schema1.table1 join schema2.table2 on .... where
.....;
if you have per schema logging, where should that get logged ?
you could implement per DATABASE logging, if you A) add the database
name to the log_prefix, and B) feed your logs to a program that
understands this and splits them out to a log file per database. you
could also do this on a per user basis. but, schema is something very
dynamic, its a namespace within a database, and queries can touch
multiiple schemas.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
