Argh, I had "phpbb" in my env ( ~/.login) too:
setenv PGDATA /var/postgresql/data
setenv PGDATABASE phpbb
setenv PGHOST /var/www/tmp
setenv PGUSER phpbb
Now everything makes sense (I was thinking
about some kind of system table for default databases).
Sorry an
Alexander Farber <[EMAIL PROTECTED]> writes:
> but I do specify the database username:
>
> h754814:afarber {109} psql --help | grep -w user
> -U NAME database user name (default: "phpbb")
>
> h754814:afarber {110} psql -U punbb
> psql: FATAL: database "phpbb" does not ex
Hi,
On 1/30/06, Doug McNaught <[EMAIL PROTECTED]> wrote:
> Alexander Farber <[EMAIL PROTECTED]> writes:
> > h754814:afarber {103} psql -U punbb
> > psql: FATAL: database "phpbb" does not exist
>
> psql uses your Unix username as the default database if you don't
> specify one.
but I do s
Alexander Farber <[EMAIL PROTECTED]> writes:
> Hello,
>
> I've created a user and a database both wrongly named "phpbb".
> After that I have renamed both to "punbb" using "ALTER DATABASE"
> and "ALTER USER". Now everything works fine, except I always
> have to specify the database when connecting
Hello,
I've created a user and a database both wrongly named "phpbb".
After that I have renamed both to "punbb" using "ALTER DATABASE"
and "ALTER USER". Now everything works fine, except I always
have to specify the database when connecting (both using psql or
the PQconnectdb() from my C-program):
