From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Gaurav Tomar <gauravtomar14(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Exception handling in Foreign table |
Date: | 2016-07-06 17:35:42 |
Message-ID: | 4c9e73a2-ab89-1d9b-5d51-bddbce04b9d3@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 07/06/2016 12:39 AM, Gaurav Tomar wrote:
> HI,
>
> I have created foreign table to read the data from the CSV file which is
> | separated.
> while reading the data from foreign table if there is any error in any
> row of the file the data is not getting loaded. I want to avoid that by
> skiping that row and continue with the next row.
> How can i achieve this.
>
> The table structure is as follows:
>
> CREATE FOREIGN TABLE location_ext
> (
> id VARCHAR(80),
> name VARCHAR(200),
> description VARCHAR(400)
> ) SERVER file_server
> OPTIONS ( filename '/home/ubuntu/location.txt', FORMAT 'csv', delimiter
> '|', header 'true' );
>
> and sample data is
>
> id|name|description
> 1|South Wing, second floor|Second floor of the Old South Wing, formerly
> in use by Psychiatry
> 2|South Wing Neuro OR 1 Old South Wing, Neuro Radiology Operation Room 1
> on second floor
> 3|Patient's Home|Patient's Home
>
> if there is an error in 2 row than while reading the data it should skip
> it and load the 1 and 3 row.
> I also want to capture the error row (2 row) as an exception.
I don't think that is possible. Just like COPY it is all or nothing.
>
> Regards,
>
> Gaurav
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | adam | 2016-07-18 15:18:42 | posgres optimizer not using the index on hstore HELP |
Previous Message | Gaurav Tomar | 2016-07-06 07:39:20 | Exception handling in Foreign table |