Re: How to use long list of columns with COPY command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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.


> 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.

Laurenz Albe

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux