From: | postgres-novice(at)coreland(dot)ath(dot)cx |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Array of C integers to temporary table? |
Date: | 2009-01-27 20:44:25 |
Message-ID: | 20090127204425.GA89472@logik.internal.network |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 2009-01-27 14:36:02, Tom Lane wrote:
> postgres-novice(at)coreland(dot)ath(dot)cx writes:
> > What's the "correct" (read: simple, efficient) way to
> > pass an arbitrarily sized array of C integers to postgres
> > and have it turned into a temporary table?
>
> > I'm using PostgreSQL 7.4.
>
> Well, the first thing to do is update to a non-dinosaurian version ;-).
> Then you could use multi-row INSERT ... VALUES. (The list of other
> benefits is far too long to enumerate here, but I'll just mention that
> 7.4 is going to stop being maintained any day now.)
I agree absolutely. Unfortunately I don't actually control the database
in question, I'm just a "guest" on it...
> An alternative that should work on 7.x is to use COPY FROM STDIN,
> but it's not really "simple" from a coding standpoint. See the libpq
> COPY-support functions.
Ok, thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | postgres-novice | 2009-01-27 20:47:55 | Re: Array of C integers to temporary table? |
Previous Message | Obe, Regina | 2009-01-27 19:47:22 | Re: Array of C integers to temporary table? |