|
|
 | | From: | Keith Worthington | | Subject: | N/A | | Date: | Fri, 14 Jan 2005 12:42:46 -0500 |
|
|
 | 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
| | From: | John DeSoi | | Subject: | Re: N/A | | Date: | Fri, 14 Jan 2005 13:32:47 -0500 |
|
|
|
On Jan 14, 2005, at 12:42 PM, Keith Worthington wrote:
> 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
>
The best way to accomplish this from the command line is to use
createdb instead of psql.
http://www.postgresql.org/docs/7.4/static/app-createdb.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
|
|
|
