Re: DATATYPE for HEX

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ilejn(at)yandex(dot)ru
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: DATATYPE for HEX
Date: 2005-06-16 14:26:20
Message-ID: 15526.1118931980@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ilja Golshtein" <ilejn(at)yandex(dot)ru> writes:
> PG Doc 49.2 says: "Each TOAST-able data type specifies a default strategy for columns of that data type". How one can find out these default strategies?

Look in pg_type, specifically the typstorage column.

Offhand I think NUMERIC is the only one that doesn't default to full
EXTENDED storage.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-16 14:32:46 Re: Hungry postmaster
Previous Message Andreas Pflug 2005-06-16 14:13:49 Re: Autovacuum in the backend