Postgres Tips

Short postgres tips that you can use every day

Articles in this series

How to generate dummy data in postgres?

Apr 8, 20212 min read

Lets create an employee table with id, name and salary columns and load some data, Create a dummy table CREATE TABLE public.employee ( id int8 NOT NULL, name varchar(120) NOT NULL, salary int8 NOT NULL, CONSTRAINT emp_pk PRIMARY KEY (...

How to generate dummy data in postgres?
Postrgres vacuum 101
Offset based pagination in postgres
How to implement keyset based pagination in postgres?
How to set application_name for psql command line utility?
Posgres materialized views