Skip site navigation (1) Skip section navigation (2)

large inserts

From: "Mark, Terry" <tmark(at)amgen(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: large inserts
Date: 1999-11-23 18:28:50
Message-ID: 548152BB0AD9D2119C400008C7CFE8C801F12FBB@gold-exch.amgen.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi all,
I am trying to do inserts which might get somewhat large.  Using Perl and
DBI, I get an error from PGQuery () saying that the query was too large.  (I
am presuming this is Postgres' message).

Is it possible to do a large insert *without* using the COPY command ? (I am
having trouble seeing how the pipes would look from within my script and
would prefer not to have to grant super-user status).  

thank you for any help,
terry

pgsql-general by date

Next:From: Qiang (John) TuDate: 1999-11-23 18:41:34
Subject: old releases of PostgreSQL ?
Previous:From: ^chewieDate: 1999-11-23 18:19:53
Subject: PL/pgsql or C/C++

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group