Skip site navigation (1)
Skip section navigation (2)
I need some help importing a csv file. I have been given a csv file full of data that is delimited by a comma, and the strings are delimited by a single quote. How do you write the copy statement to use a single quote delimiter? I have tried several things, but so far, no joy.
Thanks for any help,
Chris
Peripheral Links
Header And Logo
|
Site Navigation
How to import CSV file?
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
- Subject: How to import CSV file?
- Date: Tue, 28 Aug 2007 11:38:32 -0400
I need some help importing a csv file. I have been given a csv file full of data that is delimited by a comma, and the strings are delimited by a single quote. How do you write the copy statement to use a single quote delimiter? I have tried several things, but so far, no joy.
Thanks for any help,
Chris
- Follow-Ups:
- Re: How to import CSV file?
- From: Medi Montaseri
- Re: How to import CSV file?
- Prev by Date: How to monitor resources on Linux.
- Next by Date: Re: How to monitor resources on Linux.
- Previous by thread: How to monitor resources on Linux.
- Next by thread: Re: How to import CSV file?
- Indexes: