On Thu, Aug 27, 2009 at 7:11 PM, Martin Kersten <Martin.Kersten@cwi.nl> wrote:

Matthew Jones wrote:
> I noticed that COPY...INTO for bulk loading requires that all fields be
> present in the data file. Is there any way to use bulk loading and have
> it honor the auto increment column or at least not have to specify every
> column in the data file?

How about adding the serial column after loading. It will be zero cost.

>
> 73,
> Matthew W. Jones (KI4ZIB)
> http://matburt.net
>
>

> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users