Re: Questions on PostGreSQL Authentication mechanism...

dipti shah escribió:
> Techdb=# show hba_file;
>                hba_file
> --------------------------------------
>  /etc/postgresql/8.4/main/pg_hba.conf
> (1 row)
>
> Moreover, is there anyway to view content of this file from stored in above
> location "Techdb" command prompt itself.
>
> Techdb=# cat  /etc/postgresql/8.4/main/pg_hba.conf;

Probably pg_read_file():

select pg_read_file('pg_hba.conf', 0, 8192);

Note that pg_read_file only allows paths relative to $PGDATA, which is
what you get from SHOW data_directory;

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support