Re: [ADMIN] Scripts Importing and Authentication

2004-02-06 Thread Tom Lane
"Enio Schutt Junior" <[EMAIL PROTECTED]> writes: > So, is there a way of making the import of a script without > having to supply passwords of all different users contained > in that script? You want the script to use SET SESSION AUTHORIZATION instead of \connect. As of PG 7.4 this is the defau

[ADMIN] Scripts Importing and Authentication

2004-02-06 Thread Enio Schutt Junior
The Postgresql I use is configured to authenticate users via md5 (trust option in pg_hba.conf file) These days, after pg_dump'ing a database, and then reimporting it, Postgresql asks for the password of every user which is described by the \connect command in the script. I have used the envir