Обсуждение: Value Too long varchar(100)
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 upload db only first 100 characters. How to use this thing in copy command
On Thu, Oct 27, 2022 at 5:02 AM Rama Krishnan <raghuldrag@gmail.com> 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 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.
David J.
You should be able to do something with this if you require it to be done with COPY:
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 to be how you want it.
On Thu, Oct 27, 2022 at 7:19 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Oct 27, 2022 at 5:02 AM Rama Krishnan <raghuldrag@gmail.com> 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 upload db only first 100 characters. How to use this thing in copy commandYou 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.David J.