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