| From: | "Kevin Schroeder" <kschroeder(at)mirageworks(dot)com> | 
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> | 
| Subject: | Inserting large queries | 
| Date: | 2003-07-08 17:00:37 | 
| Message-ID: | 366a01c34572$77598690$0200a8c0@WORKSTATION | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-jdbc | 
Hello,
    I'm not quite sure if this is the proper place to post this question,
but since my problem deals with Java and PostgreSQL I figured it would be
close.
    I'm trying to do a large insert ( ~15MB) and I keep running out of
memory in my Java program when I try to do an insert through the JDBC
interface.  So I decided to try to create my insert in a file (using tab
delimiters) and use the COPY command.  However, I noticed that I can't
specify column headers when I do it that way.  That wouldn't be a problem
except that one of my columns is a primary key and needs to be
autogenerated.  How do I go about inserting my data without the primary key
header in a COPY file?
Thanks,
Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2003-07-08 17:01:46 | Re: Strange exception opening JDBC connection | 
| Previous Message | Kevin Schmidt | 2003-07-08 16:27:14 | Strange exception opening JDBC connection |