From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Copy Data Question |
Date: | 2006-06-23 19:45:59 |
Message-ID: | 20060623194559.89967.qmail@web31810.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2006-06-23 21:23:48 | Re: Copy Data Question |
Previous Message | Richard Broersma Jr | 2006-06-23 19:39:20 | Re: Copy Data Question |