Message-ID: <9b13df245873b7e5a408b5f6cffb7c2538552ed3.camel@cybertec.at>
Subject: Re: How to use long list of columns with COPY command
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: M Sarwar <sarwarmd02@outlook.com>, Holger Jakobs <holger@jakobs.com>,
	"pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Date: Mon, 12 Jun 2023 18:43:17 +0200
In-Reply-To: 
 <DM4PR19MB59786218A2CA7A09EB66AB2AD357A@DM4PR19MB5978.namprd19.prod.outlook.com>
References: 
	<DM4PR19MB59786218A2CA7A09EB66AB2AD357A@DM4PR19MB5978.namprd19.prod.outlook.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/9b13df245873b7e5a408b5f6cffb7c2538552ed3.camel%40cybertec.at>
Precedence: bulk

On Sun, 2023-06-11 at 23:04 +0000, M Sarwar wrote:
> This is my command now.
>=20
> \COPY bronx.TEST_GLOBAL_MCM_RAW (single_date_a, single_start_time_b,=C2=
=A0dual_part_m, dual_data_n ) FROM C:\Mohammed\Work\NGC\Apps\Bronx\Tables\T=
est_TestData_MCM\Test_TestData_MCM-
> LoadData\N541652_IN3799A0_CLD_ABMN.csv=C2=A0 DELIMITER ','=C2=A0 CSV Head=
er ;
>=20
> Entire above command is run from a single line.

Great.

> I need to accommodate all the below columns and few more=C2=A0 without lo=
sing=C2=A0 the legibility.
>=20
> [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