- postgresql
- what's new
- scheduler
- video
- code
•
•
•
•
-
psql on bash on Windows
1. Windows 10 supports Subsystem for Linux. 2. psql has some issues with non-English locales under Windows, see Notes for Windows Users. So I installed WSL, then choose Ubuntu, started Bash and executed: pasha_golub@PASHA:~$ sudo apt install postgresql-client Cool. Now I have native Linux psql and, of course, I want to try Pavel Stehule’s Postgres … Continue reading psql on bash on Windows
-
IsEven or IsEvenER?
How to create IsEven() function on plpgsql. #FridayPost
-
Some Warsaw pgconf.eu photos
Some more on Twitter: PostgreSQL Conference Europe 2017
-
Hackers and Bugs lists migration and GMail’s filters
Hackers and Bugs are heavy loaded lists. So it’s wise to turn notification off for them. This may be done using Gmail’s filters. “Mark as Read” is the key to success. Yesterday I began to receive strange notifications on my phone from GMail. First was from Stephen Frost, then from Tatsuo Ishii and so on. … Continue reading Hackers and Bugs lists migration and GMail’s filters
-
Serial-Identity mix
As you probably know PostgreSQL 10 introduced IDENTITY columns. They are pretty much like serial columns from the first sight. To learn about differences one may refer to the perfect blog post by Peter Eisentraut. So I was wondering what if I mix some serial with some identity. So I executed such simple query: CREATE … Continue reading Serial-Identity mix