"Ross J. Reedstrom" wrote:
> > When I went into psql, I was some of my databases with all the pg_*
> > tables. Why? Also, if I dropdb the database and createdb it again, it's
> > as if I never deleted it. Is that normal/bug/feature? Why?
> >
>
> Ah, the Debian PostgreSQL package uses a different default convention with
> psql than a from source compile: if you don't provide a database name,
> debian psql will connect you to template1. On a from source compile,
> it'll try to connect to a database that matches your username.
Bit I did specify my database name.
-Roberto
--
Computer Science Utah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto
