CREATE DATABASE question.

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE DATABASE question.
Date: 2006-07-26 23:33:11
Message-ID: 1153956791.688949.187480@m79g2000cwm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aurora 2006-07-26 23:51:28 Re: Database corruption with Postgre 7.4.2 on FreeBSD 6.1?
Previous Message Shoaib Mir 2006-07-26 23:08:40 Re: Database corruption with Postgre 7.4.2 on FreeBSD 6.1?