Re: Postgres DB - Mailing list pgsql-sql

From Tom Lane
Subject Re: Postgres DB
Date
Msg-id 20409.1077506948@sss.pgh.pa.us
Whole thread Raw
Responses Input Arguments  ("Sumita Biswas" <sbiswas@cisco.com>)
Re: Error Number in Function  ("Sumita Biswas" <sbiswas@cisco.com>)
DATEADD  ("Sumita Biswas" <sbiswas@cisco.com>)
EXECUTing QUERY:  ("Sumita Biswas" <sbiswas@cisco.com>)
Re: Postgres DB  ("Sumita Biswas" <sbiswas@cisco.com>)
Execute Query in Postgres Function  ("Sumita Biswas (sbiswas)" <sbiswas@cisco.com>)
Unicode Support  ("Sumita Biswas (sbiswas)" <sbiswas@cisco.com>)
CURSORS - Please help urgent.  ("Sumita Biswas (sbiswas)" <sbiswas@cisco.com>)
Postgres DB  ("Sumita Biswas" <sbiswas@cisco.com>)
List pgsql-sql
"Sumita Biswas" <sbiswas@cisco.com> writes:
> But when I type the command "psql" and don't specify a DB name, it says
> that:
> psql: FATAL:  Database "postgres" does not exist in the system catalog.

Yes, because psql's default behavior is to try to connect to the DB with
the same name as your user name.  That doesn't mean that such a DB is
guaranteed to exist, or even that anything is going to try to create it
for you.  It's just a default behavior that people have found handy.
        regards, tom lane


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Compiling pl/pgsql functions
Next
From: Christopher Browne
Date:
Subject: Re: User defined types -- Social Security number...