Re: Copy Data Question

[Richard Broersma Jr <rabroersma(at)yahoo(dot)com>]

OOPS,  I forgot something else.

--- Richard Broersma Jr <rabroersma(at)yahoo(dot)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
>