Wow!!..that was too quick. Thanks Richard. On Tue, Feb 2, 2010 at 3:29 PM, Richard Huxton <d...@archonet.com> wrote:
> On 02/02/10 09:55, dipti shah wrote: > >> Thanks Richard and Alvaro. The "show hba_file" is great solution. Thanks a >> ton. Could you tell me from where to get all such commands? >> > > All the configuration settings are listed in Chapter 18: > http://www.postgresql.org/docs/8.4/static/runtime-config.html > > You'll also find details in the SQL reference for SET and SHOW: > http://www.postgresql.org/docs/8.4/static/sql-set.html > http://www.postgresql.org/docs/8.4/static/sql-show.html > > "SHOW ALL" will list all the settings in one big table. > > -- > Richard Huxton > Archonet Ltd >
