Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to import CSV file?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
- Cc: Chris Hoover <revoohc(at)gmail(dot)com>, Medi Montaseri <montaseri(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: How to import CSV file?
- Date: Tue, 28 Aug 2007 15:34:42 -0400
- Message-id: <1966.1188329682@sss.pgh.pa.us> <text/plain>
Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes: > On Tue, 28 Aug 2007, Chris Hoover wrote: >> Why go through all of this when COPY can handle this for you? All I need to >> know is the syntax to tell copy that the strings are quoted by a single >> quote. > Probably you want to try something like: > COPY foo FROM '/tmp/foo' WITH CSV QUOTE AS '\''; Actually I'd recommend WITH CSV QUOTE AS '''' ... the backslash syntax is nonstandard and will bite you eventually. Doubled quote works in every version of PG. regards, tom lane
- References:
- How to import CSV file?
- From: Chris Hoover
- Re: How to import CSV file?
- From: Medi Montaseri
- Re: How to import CSV file?
- From: Chris Hoover
- Re: How to import CSV file?
- From: Jeff Frost
- How to import CSV file?
- Prev by Date: Re: How to monitor resources on Linux.
- Next by Date: Re: How to monitor resources on Linux.
- Previous by thread: Re: How to import CSV file?
- Next by thread: pg_dump object dump-order
- Indexes: