On 5/8/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
Right now the software that does the extracts is developed by our
applications developers, but I'll be taking that onto my side in the
near future, just looking for a workaround until then.
Sorry, but there isn't one. An unqualified COPY expec
Phillip Smith wrote:
Can you modify the 'extract' and make the extra column "\n" which is the
null escape?
That would be the only other option.
Right now the software that does the extracts is developed by our
applications developers, but I'll be taking that onto my side in the
near future
stgresql.org
Subject: Re: [SQL] Query RE using COPY
Jonah H. Harris wrote:
> COPY mytbl (col1, col2, col3, col4, col6) FROM 'myfile.txt' WITH
> DELIMITER AS '^' QUOTE '\f' CSV HEADER;
>
>
I would rather not do it this way as I use the same load script
Jonah H. Harris wrote:
COPY mytbl (col1, col2, col3, col4, col6) FROM 'myfile.txt' WITH
DELIMITER AS '^' QUOTE '\f' CSV HEADER;
I would rather not do it this way as I use the same load script at all
customer sites where the extracts and requirements may vary. I.e. one
customer may not use t
COPY mytbl (col1, col2, col3, col4, col6) FROM 'myfile.txt' WITH
DELIMITER AS '^' QUOTE '\f' CSV HEADER;
On 5/7/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
I use the COPY command to load data from a file into tables in my database.
The following is an example done in psql:
COPY deals_t
I use the COPY command to load data from a file into tables in my database.
The following is an example done in psql:
COPY deals_temp_load FROM 'c:/temp/autodrs_deals.txt' WITH DELIMITER AS
'^' QUOTE '\f' CSV HEADER;
If a column is added to the table but has not been added to the extracts
wh
