Categories
auto-increment mysql postgresql postgresql-9.5

PostgreSQL’s SERIAL vs MySQL’s AUTO_INCREMENT?

Categories
postgresql postgresql-9.5 sql sql-insert upsert

Can INSERT […] ON CONFLICT be used for foreign key violations?

Categories
postgresql postgresql-9.5 sql

ON CONFLICT DO UPDATE has missing FROM-clause

Categories
pagination postgresql postgresql-9.5 sql sql-order-by

Optimize query with OFFSET on large table

Categories
postgresql postgresql-9.5 sql

Conditionally select a column in postgres SQL

Categories
postgresql postgresql-9.5 sql

Change default schema for user

Categories
json jsonb postgresql postgresql-9.5

Return jsonb_array_elements result as comma-separated list

Categories
json postgresql postgresql-9.5

Postgres 9.5 – Querying array length of a nested JSON element

Categories
arrays postgresql postgresql-9.5

Adding value to Postgres integer array

Categories
postgresql postgresql-9.5 row-level-security sql views

Why isn’t row level security enabled for Postgres views?