CREATE WRITABLE EXTERNAL TABLE gtr_temp.ext_temp4(trade_side_id integer,
obligation character varying(50) )
LOCATION ('gpfdist://172.30.218.130:8880/Ext_temp4.CSV')
FORMAT 'csv' (DELIMITER ',')
DISTRIBUTED RANDOMLY ;
insert into gtr_temp.ext_temp4 select trade_side_id,'"'||obligation||'"' from gtr_temp.temp1
I want the column to wrap with quotes
populating an external table with quotes
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne