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 upload db only first 100 characters. How to use this thing in copy command
You cannot. Either fix the content of the file or remove the arbitrary length limitation on the field (i.e., change the type to "text"). I suggest the later. You may also,copy into a temporary staging table that lacks the limit, then use insert to move the transformed data (via a select query) into the production table.