[SQL] Help needed in skipping column for copy command

2011-01-17 Thread Amar Dhole
I have table created as follows CREATE TABLE D_2147483927_2147484848_TAB( CP VARCHAR(256) , CPR VARCHAR(256) , CHOUSENO VARCHAR(256) , CSTREET VARCHAR(256) , CLOCALITY VARCHAR(256) , CCITY VARCHAR(256) , CPROVINCE VARCHAR(256) , CCOUNTRY VARCHAR(256) , CZIP VARCHAR(256) , CCO

Re: [SQL] Help needed in skipping column for copy command

2011-01-17 Thread Adrian Klaver
On 01/17/2011 05:59 AM, Amar Dhole wrote: I have table created as follows CREATE TABLE D_2147483927_2147484848_TAB( CP VARCHAR(256) , CPR VARCHAR(256) , CHOUSENO VARCHAR(256) , CSTREET VARCHAR(256) , CLOCALITY VARCHAR(256) , CCITY VARCHAR(256) , CPROVINCE VARCHAR(256) , CCOUNTRY

Re: [SQL] Help needed in skipping column for copy command

2011-01-17 Thread Russell Galyon
COPY D_2147483927_2147484848_TAB ( CP , CPR , CHOUSENO , CSTREET , CLOCALITY , CCITY , CPROVINCE , CCOUNTRY , CZIP ) FROM 'one.txt' WITH DELIMITER ',' QUOTE '' csv HEADER; On Mon, Jan 17, 2011 at 7:59 AM, Amar