Re: Problems importing csv files - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problems importing csv files
Date
Msg-id 29667.1245701405@sss.pgh.pa.us
Whole thread Raw
In response to Problems importing csv files  (Kindra Martinenko <kindramart@yahoo.com>)
List pgsql-novice
Kindra Martinenko <kindramart@yahoo.com> writes:
> I created a table that mimics the csv table I want to read from.  I set privleges to "All" and have been attempting
toexecute the following procedure: 

> COPY BaxterCommercial WITH OIDS FROM 'H:\...\BaxterCommercial.csv'
> USING DELIMITERS ',';

You need to double the backslashes, or perhaps replace them with forward
slashes.  Read about string literal syntax here:
http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS

            regards, tom lane

pgsql-novice by date:

Previous
From: Kindra Martinenko
Date:
Subject: Problems importing csv files
Next
From: Robert Schnabel
Date:
Subject: Re: Problems importing csv files