Skip site navigation (1) Skip section navigation (2)

Re: control pg_hba.conf via SQL

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: control pg_hba.conf via SQL
Date: 2006-03-30 15:43:31
Message-ID: 442BFCA3.2090700@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
A.M. wrote:
> Could postgres offer at least a read-only view of the data in the interim?
> Ordering could be controlled by line number.
>   

You can get the contents as a single text field like this:

|  select pg_read_file|('pg_hba.conf', 0, 50*1024);


Writing a plperl function that would strip comments and blank lines and 
return the rest as a numbered set of lines would be fairly trivial.


cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Steve LinaberyDate: 2006-03-30 16:00:42
Subject: can't get connection during pg_dump
Previous:From: A.M.Date: 2006-03-30 15:21:21
Subject: Re: control pg_hba.conf via SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group