3 ms·
That's how every Postgres extension works (e.g. Timescale, PostGIS, etc.)
by pcthrowaway 4y ago
That's how every Postgres extension works (e.g. Timescale, PostGIS, etc.)
- firloop 4y agoNot just Postgres extensions, most of Postgres’ own administrative functions can be triggered in SELECT statements. e.g. pg_terminate_backend() https://www.postgresql.org/docs/current/functions-admin.html https://www.postgresql.org/docs/current/functions-admin.html
- yjftsjthsd-h 4y agoTo be quite clear, that always felt weird to me as well - something to the effect of "I thought SELECT was for reading data; why am I using it to create a replica?"