You should be able to do something with this if you require it to be done
with COPY:
https://paquier.xyz/postgresql-2/postgres-9-3-feature-highlight-copy-tofrom-program/
But, as David suggested, I'd also recommend to do an intermediate step, and
load the data into a table, or pre-process the file
On Thu, Oct 27, 2022 at 5:02 AM Rama Krishnan wrote:
> Hi team,
>
> We are getting csv file from client to upload data in my db table , one
> particular column I. E clinet description column contains more than 100
> character hence I am getting value too long varchar (100) so we decided to
> upl
