From: Fred Parkinson <FredP@abag.ca.gov>
To: pgsql-admin@postgresql.org
Subject: Starting psql without a database?
Date: Wed, 27 Apr 2011 11:44:45 -0700
Message-ID: <4DB801AD020000A700017012@gwia1.abag.ca.gov> (raw)
References: <4DB7EF0B020000A700017002@gwia1.abag.ca.gov>
<4DB801AD020000A700017012@gwia1.abag.ca.gov>
Folks
As I have been unable to install pgadmin3 on my OpenSUSE Linux 10 box (erroneously described as 11.2 in the request for help post, that was useless), I have decided to use psql since it seems to be my only option.
However, I have no database as yet, and when I type in a console 'psql' I get the message "psql: FATAL: database 'username' does not exist"
So I try to start by sending the createdb command, as in: "psql -c createdb -T DEFAULT 'timecard'" but this returns the error "psql: FATAL: database "timecard" does not exist"
I tried using the database 'postgres' which seems to be created during the install:
psql postgres, which takes me to a psql prompt. However, the command createdb -T DEFAULT "timecard" now results in the error "syntax error at or neat "createdb" with a carat pointing to the 'c' in 'createdb'.
As usual, stuck again!
Any ideas greatly appreciated.
Fred
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: FredP@abag.ca.gov
Subject: Re: Starting psql without a database?
In-Reply-To: <4DB801AD020000A700017012@gwia1.abag.ca.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox