Re: [GENERAL] Multiple insert

On 09/19/2015 11:31 AM, FarjadFarid(ChkNet) wrote: Hi, I am getting errors trying to insert multiple records in single statement in table like this CREATE TABLE "Lookup"."CNEnum1" ( "Id" integer NOT NULL, "Description" character varying(50), CONSTRAINT "PK_Lookup_CNEnum1 " PRIMARY

[GENERAL] Multiple insert

Hi, I am getting errors trying to insert multiple records in single statement in table like this CREATE TABLE "Lookup"."CNEnum1" ( "Id" integer NOT NULL, "Description" character varying(50), CONSTRAINT "PK_Lookup_CNEnum1 " PRIMARY KEY ("Id") ) WITH ( OIDS=FALSE );

Re: [GENERAL] Multiple insert

You are inserting ((),()). It should be (),(). Skip the outer set of parentheses. On September 19, 2015 2:31:53 PM EDT, "FarjadFarid(ChkNet)" wrote: >Hi, > > > >I am getting errors trying to insert multiple records in single >statement in >table like this > >

Re: [GENERAL] Multiple insert

On 09/19/2015 11:31 AM, FarjadFarid(ChkNet) wrote: Hi, I am getting errors trying to insert multiple records in single statement in table like this CREATE TABLE "Lookup"."CNEnum1" ( "Id" integer NOT NULL, "Description" character varying(50), CONSTRAINT "PK_Lookup_CNEnum1 " PRIMARY

Re: [GENERAL] multiple insert into's (may be NEWBIE question)

On 5 Aug 2003, Ron Johnson wrote: On Tue, 2003-08-05 at 14:42, Stephan Szabo wrote: On Tue, 5 Aug 2003, scott.marlowe wrote: On Tue, 5 Aug 2003, Williams, Travis L, NPONS wrote: I have a table (lets say a,text b,text) and I want to insert the data jim,jimmy and trav,travis can

Re: [GENERAL] multiple insert into's (may be NEWBIE question)

On Tue, 5 Aug 2003, Williams, Travis L, NPONS wrote: I have a table (lets say a,text b,text) and I want to insert the data jim,jimmy and trav,travis can I do this with 1 insert into statement instead of 2? Not with the current implementation of insert. There's been some discussion of

Re: [GENERAL] multiple insert into's (may be NEWBIE question)

Didn't know if it would be any faster.. Travis -Original Message- From: Ron Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:00 PM To: PgSQL General ML Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question) On Tue, 2003-08-05 at 14:42, Stephan Szabo

Re: [GENERAL] multiple insert into's (may be NEWBIE question)

Thanks.. Travis -Original Message- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 2:16 PM To: Williams, Travis L Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question) On Tue, 5 Aug 2003, Williams, Travis L, NPONS

[GENERAL] multiple insert into's (may be NEWBIE question)

I have a table (lets say a,text b,text) and I want to insert the data jim,jimmy and trav,travis can I do this with 1 insert into statement instead of 2? Travis ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

[GENERAL] Multiple INSERT

Hello everyone! I have readen in the doc of PostgreSQL that we can insert several tuples in a table at one time. But it is said that the tuples to insert must be the result of a SELECT. Could someone explain me what is the advantage of that technique ? Because if I have to build a temporary

Re: [GENERAL] Multiple INSERT

Could someone explain me what is the advantage of that technique ? Because if I have to build a temporary table before being able to perform multiple INSERT, I work 2 times more, isn't it ? Or perhaps does it exist a way to perform multiple insert without build a temporary table; something