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(dot)klaver(at)gmail(dot)com