Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to import CSV file?
- From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
- To: Chris Hoover <revoohc(at)gmail(dot)com>
- Cc: 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 11:11:16 -0700 (PDT)
- Message-id: <Pine.LNX.4.64.0708281109470.31586@discord.home.frostconsultingllc.com> <text/plain>
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.
Check out the docs here: http://www.postgresql.org/docs/8.1/interactive/sql-copy.html Probably you want to try something like: COPY foo FROM '/tmp/foo' WITH CSV QUOTE AS '\''; -- Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
- Follow-Ups:
- Re: How to import CSV file?
- From: Tom Lane
- Re: How to import CSV file?
- 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
- 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: Re: How to import CSV file?
- Indexes: