Yes,
But create text allows you to store more data,
8.3. Character Types
*Table 8.4. Character Types*
Name Description
|character varying(/|n|/)|, |varchar(/|n|/)| variable-length with limit
|character(/|n|/)|, |char(/|n|/)| fixed-length, blank padded
|text| variable unlimited length
On 20/07/2023 16:46, Laurenz Albe wrote:
> On Thu, 2023-07-20 at 15:46 +0200, Jef Mortelle wrote:
>> So: not possible to have very little downtime if you have a database
>> with al lot rows containing text as datatype, as pg_upgrade needs 12hr
>> for 24 milj rows in pg_largeobject.
> To clarify: "text" is no problem at all. Large objects are.
>
> Yours,
> Laurenz Albe