| From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | How to use long list of columns with COPY command |
| Date: | 2023-06-11 21:44:06 |
| Message-ID: | DM4PR19MB597823375C3368B62256F717D357A@DM4PR19MB5978.namprd19.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I have some problem while loading the data using COPY command.
My environment:
Amazon RDS
Postgres - Database
PgAdmin -- with PSQL tool.
Command -- COPY
I am trying to use COPY command to load the data. Table TEST_GLOBAL_MCM_RAW has 209 columns. In COPY command, I am trying to use around 200 columns to load the data.
When I try to span COPY command into multiple lines, COPY command is not working. I am forced to use all the command in a single line and which is not legible.
Do I have any options to make the COPY command legible while using all the columns of any table.
I have tried \n and this is not working.
It is possible that someone has faced this situation in the past.
Thank you,
Sarwar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2023-06-11 21:54:15 | Re: How to use long list of columns with COPY command |
| Previous Message | MichaelDBA | 2023-06-11 14:15:06 | Re: Obtaining the size of temp tables in current sesion |