From: | "Keith Worthington" <keithw(at)narrowpathinc(dot)com> |
---|---|
To: | "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | N/A |
Date: | 2005-01-14 17:42:46 |
Message-ID: | 20050114174246.M80221@narrowpathinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi All,
I thought that I could quickly create a new and empty database using psql but
I obviously have the syntax messed up. I have already worked around the issue
by using pgadmin but I would appreciate your time if you could explain the
correct way to accomplish this with psql. TIA
# psql --username postgres --echo-all --command "CREATE DATABASE NEW_DB WITH
ENCODING = 'SQL_ASCII';"
psql: FATAL: Database "postgres" does not exist in the system catalog.
# psql --dbname template1 --username postgres --echo-all --command "CREATE
DATABASE NEW_DB WITH ENCODING = 'SQL_ASCII';"
CREATE DATABASE NEW_DB WITH ENCODING = 'SQL_ASCII';
ERROR: CREATE DATABASE: source database "template1" is being accessed by
other users
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-01-14 18:32:47 | Re: N/A |
Previous Message | sarlav kumar | 2005-01-14 15:27:06 | Re: [PERFORM] query optimization help |