pg_timetable: Advanced PostgreSQL cron-like scheduler released!
pg_timetable: Advanced PostgreSQL cron-like scheduler released! Hello there, this is your developer speaking... I'm struggling with how to start this […]
PSQL_EDITOR: Fighting with Sublime Text under Windows
This is a How-To blog about the PSQL_EDITOR variable. While trying to figure out all possible pitfalls, I've somehow managed […]
Building PostgreSQL (x86, x64) and OpenSSL using MSYS2 and MinGW under Windows
I've written already a blog post "Building PostgreSQL with MSYS2 and MinGW under Windows" a year ago. But this time […]
1-to-1 relationship in PostgreSQL for real
How to implement 1-to-1 relationship in PostgreSQL? Tricks with UNIQUE constraints? Check how to achive that using DEFERRABLE foreign keys.
Choose plpgsql variable names wisely
Pavel Stehule recently wrote the post "Don't use SQL keywords as PLpgSQL variable names" describing the situation when internal stored […]
In this blog posting we will tell you more about how to use keywords exactly in PostgreSQL and e.g. what keywords may be used as object names
Building PostgreSQL with MSYS2 and MinGW under Windows
In this blog you will learn how to build PostgreSQL from sources under Windows using MSYS2 and MinGW-64 in easy steps.
