From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | M Sarwar <sarwarmd02(at)outlook(dot)com>, Holger Jakobs <holger(at)jakobs(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: How to use long list of columns with COPY command |
Date: | 2023-06-12 16:43:17 |
Message-ID: | 9b13df245873b7e5a408b5f6cffb7c2538552ed3.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sun, 2023-06-11 at 23:04 +0000, M Sarwar wrote:
> This is my command now.
>
> \COPY bronx.TEST_GLOBAL_MCM_RAW (single_date_a, single_start_time_b, dual_part_m, dual_data_n ) FROM C:\Mohammed\Work\NGC\Apps\Bronx\Tables\Test_TestData_MCM\Test_TestData_MCM-
> LoadData\N541652_IN3799A0_CLD_ABMN.csv DELIMITER ',' CSV Header ;
>
> Entire above command is run from a single line.
Great.
> I need to accommodate all the below columns and few more without losing the legibility.
>
> [long column list]
You will have to write a long line with all the columns in it, and if that's not
very legible, that's what you get for using wide tables.
\copy has to be in a single line.
> I have tried with \n option and that is not working.
I don't understand what you mean by that.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Norbert Poellmann | 2023-06-12 17:01:27 | Re: How to use long list of columns with COPY command |
Previous Message | M Sarwar | 2023-06-11 23:45:51 | Re: How to use long list of columns with COPY command |