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
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
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
>
>
>
>CREATE TABLE "Lookup"."CNEnum
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
);
INSER
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, Ste
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 ad
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 an
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,
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 approp
> 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; somethi
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 tabl
11 matches
Mail list logo
