N/A

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