Re: Changing Passwords as Encrypted not Clear-Text

On Monday, December 19, 2011 7:26:33 am MURAT KOÇ wrote:
> Hi Adrian,
> 
> I wrote a desktop application on Windows by using "Npgsql.dll". So, I send
> SQL statement to database from this application code. I can't use psql
> command line (I know "\password" command changes password encrypted text).
> 
> Because of this, I have to use "ALTER USER" statement from application
> code. Or what could you give another advice?

Another option would be to change logging behavior on the fly using SET:

http://www.postgresql.org/docs/9.0/interactive/sql-set.html

set log_statement= 'none';


This will need to be done as a superuser. 

> 
> Best Regards
> Murat KOC
> 

-- 
Adrian Klaver
adrian.klaver@gmail.com