Re: CREATE DATABASE question.

Karen Hill wrote:
> 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?

Sure, just lose the trailing semi-colon from your connect command, as in:

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

This lets psql interpret your connect request as a psql command instead
of as an SQL statement.

Regards,
Eric Faulhaber