Skip to content

Instantly share code, notes, and snippets.

View andyatkinson's full-sized avatar

Andrew Atkinson andyatkinson

View GitHub Profile
psql> create table t(a uuid, b text, c char(36));
CREATE TABLE
psql> insert into t values (gen_random_uuid(), 'some amount of text', 'some amount of text');
INSERT 0 1
psql> select pg_column_size(a), pg_column_size(b), pg_column_size(c) from t;
pg_column_size | pg_column_size | pg_column_size
----------------+----------------+----------------
16 | 20 | 37