From: | Gaurav Tomar <gauravtomar14(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Exception handling in Foreign table |
Date: | 2016-07-06 07:39:20 |
Message-ID: | CAByYU3QW=LfWHy4B8LAuFqomnO_WB0vrHx0Cn3u05PQrOaTpSQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
Regards,
Gaurav
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-07-06 17:35:42 | Re: Exception handling in Foreign table |
Previous Message | Steve Midgley | 2016-07-01 22:20:13 | Re: missing data for column |