3 ms·
PL/pgSQL supports entities? This is kind of amazing. Do you have a resource to pick this skill up?
by Something1234 8y ago
PL/pgSQL supports entities? This is kind of amazing. Do you have a resource to pick this skill up?
- dizzystar 8y agoI guess I should be more specific by what I mean by entities. I probably used the wrong word here: https://www.postgresql.org/docs/10/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN https://www.postgresql.org/docs/10/static/plpgsql-statements... PL/pgSQL gives you %I and %L, which allows you to specify table and column names. Basically, if you want to `select * from %I`, you have the option to call the specific table.
- Something1234 8y agoSo what's the best way to leverage this feature in crud applications?