CREATE DATABASE question. - Mailing list pgsql-general

From Karen Hill
Subject CREATE DATABASE question.
Date
Msg-id 1153956791.688949.187480@m79g2000cwm.googlegroups.com
Whole thread Raw
Responses Re: CREATE DATABASE question.  (Eric Faulhaber <ecf@goldencode.com>)
List pgsql-general
I have an sql file that doesn' t work properly when I do: psql <
mysql.sql .  I cannot get it to connect to the database.

Here what I'd like it to do:

CREATE DATABASE testdb;
\c testdb;
CREATE TABLE tableTest(var varchar);

But I get an error on the second line about an invalid character.  Is
it even possible to connect to a different db when giving an sql file
to psql to process?

regards,


pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: Database corruption with Postgre 7.4.2 on FreeBSD 6.1?
Next
From: aurora
Date:
Subject: Re: Database corruption with Postgre 7.4.2 on FreeBSD 6.1?