[ADMIN] get PGDATA as non-postgres user

Hi I need to get PGDATA location when I logged in as non-postgres user. I cannot see data_directory from pg_setting table as non-postgres user. Any work around? Any other way to retrieve that information? If not, what is the quickest way to enable non-postgres user to have PGDATA

Re: [ADMIN] get PGDATA as non-postgres user

Am Donnerstag, 3. Januar 2008 schrieb Sofer, Yuval: I need to get PGDATA location when I logged in as non-postgres user. Consider writing a security-definer function that retrieves the information. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of