From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Copy Data Question |
Date: | 2006-06-23 21:46:49 |
Message-ID: | 20060623214649.82567.qmail@web33307.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>
> > ;
the delimiter is the tab, which is the default. i
don't think i need to include it. i don't what i'd
put in place of 'delimiter' to represent tab, anyhow.
i'm not getting CSV QUOTE. should by statement look
like:
CSV QUOTE AS '''
if i'm using a ' as my quote?
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-06-23 21:54:35 | Re: Copy Data Question |
Previous Message | operationsengineer1 | 2006-06-23 21:23:48 | Re: Copy Data Question |