Search Postgresql Archives

Re: Value Too long varchar(100)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, Oct 27, 2022 at 5:02 AM Rama Krishnan <raghuldrag@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux