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,
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq