Preface There are a lot of tools for PostgreSQL development. I want to propose you one more. Why Lazarus: Lazarus is shipped with open-source Pascal compiler; it has a high degree of Delphi compatibility; availability on a variety of platforms,…
Pasha Golub's Blog
Nullus est in vitae sensus, ipsa vera est sensus
Blog Archives
Do we need LIMIT clause in UPDATE and DELETE statements for PostgreSQL?
Was working with MySQL recently. Noticed that UPDATE command of it has special LIMIT clause which is really useful as for me, e.g. UPDATE `Product_download` SET `version`=’9.2.1′ WHERE `product_download_id`=367 LIMIT 1;
Posted in Polls, PostgreSQL
Number into words convertion in PostgreSQL
I was playing with some unit tests for PostgresDAC recently. And one test case was to check TPSQLDataset.Locate routine which allows partial-string and case-sensitive matching options. So I want to have some test result set with integer and text columns.…
PGConf.EU 2012: My schedule
Well, I suppose it’s time to choose the most interesting talks to visit at PGConf.EU 2012. I sketched out a rough list. Wednesday, October 24 11:10 – 12:00 Writing a foreign data wrapper Bernd Helmle 12:10 – 13:00 MultiMaster Replication:…
How to move data from one schema to another in Postgres?
I saw a question today : I have PostpreSQL 9.1. In my database there are 2 schemas: public and test. How can I quickly move all objects and data from public to test? Opps. I’m stuck with this issue for…
- Database Designer for PostgreSQL 1.9.0 is out! May 17, 2013
- Database Designer for PostgreSQL 1.9.0 Beta 2 available April 15, 2013
- PostgresDAC v2.9.6 is out! May 14, 2013
- PostgresDAC v2.9.5 released April 18, 2013
- PaGoDump and PaGoRestore v9.2.1 released November 23, 2012
- PaGoDump and PaGoRestore v9.1.3 are available June 6, 2012
- Shaun M. Thomas: Winning (Free eBooks) is Everything May 21, 2013
- Josh Berkus: PostgreSQL New Development Priorities 5: New User Experience May 21, 2013
- Bruce Momjian: Video Interview May 21, 2013
- Josh Berkus: PostgreSQL New Development Priorities 4: Parallel Query May 21, 2013
- Selena Deckelmann: Distributed databases: a series of posts including 2-phase commit in Postgres May 21, 2013
