Re: Psql Question

Danny writes:

> mydb=# INSERT INTO Customer (Customer_ID,Customer_Name,Customer_Address,Customer_Email)
> mydb-# VALUES ('1','Danny Ho','99 Second Ave, Kingswood','dannyh(at)customer(dot)com'),
> mydb-# ('2','Randal Handel','54 Oxford Road, Cambridge','randalh(at)customer(dot)com')
> mydb-# ;
>
> -and I get the following errors :
>
> ERROR: parser: parse error at or near ","

PostgreSQL doesn't support this syntax (yet). You need to split it into
two INSERT commands.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/