Search Postgresql Archives

Re: Regarding varchar max length in postgres

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

 





On Mon, Oct 15, 2018 at 9:07 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Mon, Oct 15, 2018 at 8:24 AM Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> wrote:
So i need unlimited length data type for required column of the table for storing the large values 
is there any issue to use unlimited length datatype  text  for the required column of the table instead of using varchar ?

Between the two you should use the "text" data type for those columns.  You will need to describe your use case in more detail if you want input as to whether you need to use the large object API instead.

The database cannot store an unlimited amount of data in a single row+column (cell) - you will still encounter a physical limit to the number of bytes able to be stored in a single cell when using text.

David J.


Hi sir

 i need to store more values on required column of the table by using text  than varchar 

you said that physical limit needs to be stored values  in column of the table 

textvariable unlimited length



Thank you for this valuable information 

 PostgreSQL is always no 1 world s leading open source  RDBMS



 I request you all community members to provide built in bdr v3 version replication for public as multimaster replication is on high priority  against other dbms 

[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux