Re: Copy Data Question - Mailing list pgsql-novice

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
>