From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jialun Zhang <reatank@gmail.com>
cc: pgsql-novice@lists.postgresql.org
Subject: Re: How to change the default storage strategy for varlena?
In-reply-to: 
 <CAMFL+JhcUkOchrKcBLecLC_Nc_23DRkueMDzuRQgVt_r-S2BKQ@mail.gmail.com>
References: 
 <CAMFL+JhcUkOchrKcBLecLC_Nc_23DRkueMDzuRQgVt_r-S2BKQ@mail.gmail.com>
Comments: In-reply-to Jialun Zhang <reatank@gmail.com>
	message dated "Thu, 23 Jul 2020 16:37:48 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <299364.1595539814.1@sss.pgh.pa.us>
Date: Thu, 23 Jul 2020 17:30:14 -0400
Message-ID: <299365.1595539814@sss.pgh.pa.us>
Precedence: bulk

Jialun Zhang <reatank@gmail.com> writes:
> The defualt stroage strategy for varlena is 'x', i.e. EXTENDED. Is there a
> way to change it, from either front end or source code?

As of v13 you could do something like

alter type varchar set (storage = main);

(repeat for every varlena type in the system, if that is indeed your
desire).  This seems like a remarkably bad idea, but it's breaking
nobody's database but your own.

			regards, tom lane