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