Psql Question

- Hello
- I had previous experience with Access and MySQL.

-Situation

- I am trying to create the equvilant of the following which is a mysql
command.

- Queston
- But I cannot figure out how to do this is postgresql

"mysql -u root -p mydb < mydb.dump"

- I was trying to create a test database using the following commands using a
very cliche example . This command works on mySQL and should be part of the
ANSI SQL standard


mydb=# INSERT INTO Customer (Customer_ID,Customer_Name,Customer_Address,Customer_Email)
mydb-# VALUES ('1','Danny Ho','99 Second Ave, Kingswood','dannyh@customer.com'),
mydb-# ('2','Randal Handel','54 Oxford Road, Cambridge','randalh@customer.com')
mydb-# ;

-and I get the following errors :

ERROR:  parser: parse error at or near ","

Looking forwrd to your feedback.,

dannyh

dannyH@dix.com.au