Mastodon

See all posts by Frédéric Delacourt

Blog RSS feed
An image visually showing the article title.
Free Software, Open Source, PostgreSQL, Programming

Did you know? Tables in PostgreSQL are limited to 1,600 columns

It's a hard-coded limit in Postgres for tables to not exceed 1,600 columns. Let's test all the ways you can reach that limit, and explore how to address the situation when you reach this limit unexpectedly.

by Frédéric Delacourt
An image representing the unexpected data type transformations detailed in this blog.
Free Software, PostgreSQL, Programming

Strange data type transformations

An in depth look at strange data type transformations, when your function argument types might be changed differently than you expect.