On Tue, Jul 24, 2001 at 01:09:42PM -0500, will trillich wrote:
> to connect to a remote postgresql server, we can use psql thus:
> 
>       psql -h 192.168.1.2 distantdbname

but not the old-fashioned

        psql [EMAIL PROTECTED]

any more. how come?

> with psql v7.0.3 i could be INSIDE psql already and do
> 
>       somedb=# \c anotherdb
>       anotherdb=# \c [EMAIL PROTECTED]
>       remotedb=# \d
> 
> but with 7.1 i get
> 
>       somedb=# \c anotherdb
>       anotherdb=# \c [EMAIL PROTECTED]
>       FATAL 1:  Database "[EMAIL PROTECTED]" does not exist in the system 
> catalog.
>       Previous connection kept
>       anotherdb=# \q
> 
> is there a fix i missed?

i asked this on the postgresql-general list, and they're
pointing me back to the debian-specific port... :/

would it be "Bad Dog" to write a wrapper to take care of the
command-line "psql [EMAIL PROTECTED]" portion at least?

-- 
DEBIAN NEWBIE TIP #71 from Joost Kooij <[EMAIL PROTECTED]>
:
So exactly WHICH SHELL ARE YOU RUNNING? Simply try
        echo $SHELL
or
        printenv SHELL
AFAIK any shell that does not set $SHELL is broken.

Also see http://newbieDoc.sourceForge.net/ ...

Reply via email to