Re: Psql Question - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Psql Question
Date
Msg-id Pine.LNX.4.21.0009192049420.362-100000@peter
Whole thread Raw
In response to Psql Question  (Danny <dannyh@idx.com.au>)
List pgsql-general
Danny writes:

> 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 ","

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

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: postgres-user <-> unix user
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: postgres-user <-> unix user