Horton
Menu

Re: Postgres do not support tinyint?

Dominique Devienne <ddevienne@gmail.com>

View thread
From: Dominique Devienne <ddevienne@gmail.com>
To: Vladlen Popolitov <v.popolitov@postgrespro.ru>
Cc: Igor Korot <ikorot01@gmail.com>, Christophe Pettus <xof@thebuild.com>, "David G. Johnston" <david.g.johnston@gmail.com>, Ron Johnson <ronljohnsonjr@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-01-10T09:41:12Z
Lists: pgsql-general 
On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov
<v.popolitov@postgrespro.ru> wrote:
> If you really need 1-byte integer, you can use "char" type. Cast it
> to/from int. See comment at the end of the page
> https://www.postgresql.org/docs/17/datatype-character.html

Hi. What would be the best online doc to learn about the physical
storage / format for rows/pages/btree, etc... To understand alignment,
packing, varint or not, all those things. I'm quite familiar with the
[SQLite format][1], having read that doc dozens of times, and I'd like
a better low-level understanding for PostgreSQL as well. TIA, --DD

[1]: https://www.sqlite.org/fileformat.html