OOPS, I forgot something else.
--- Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> > i have 11 columns total. column 1, 2, 3, 4, 5 and 6
> > are NOT NULL. the rest can be null and, in the case
> > of the imported data set, are null.
>
> From:
> http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
>
> COPY tablename ( column [, ...] )
>
> FROM 'filename'
>
> WITH NULL AS 'null string'
DELIMITER AS 'delimiter'
CSV QUOTE AS 'quote'
FORCE NOT NULL column1, column2, column3, column4, column5, column6
> ;
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>