#73: Allow inserttable() to take columns as parameter
--------------------------+--------------------
Reporter: cito | Owner:
Type: enhancement | Status: closed
Priority: minor | Milestone: 5.1
Component: DB API 2 | Version: 5.0
Resolution: wontfix | Keywords:
--------------------------+--------------------
Comment (by cito):
Justin: I don't think we're talking about the same thing. The request was
to allow inserting columns "a,c" into a table with columns "a,b,c,d" (we
need to do this all the time). That's needed in case columns b,d have
default values (otherwise NULL would work fine).
Doesn't this just need to accept an optional list of column names and join
them with commas?
{{{sprintf(buffer, "copy %s from stdin", table);}}}
to allow:
{{{COPY t(i) FROM stdin}}}
I don't know for sure if we'd be able to use this for either of our
loaders, but I suspect it would be competitive or better than prepared
statements, for use cases where it can be applied.
--
Ticket URL: <http://trac.pygresql.org:8000/pgtracker/ticket/73#comment:2>
PyGreSQL <http://www.pygresql.org/>
PyGreSQL Tracker
_______________________________________________
PyGreSQL mailing list
[email protected]
https://mail.vex.net/mailman/listinfo/pygresql
