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/ ...