Blog Archives

Get PostgreSQL sources using SVN

As you probably know PostgreSQL sources are managed by Git version control system. Which is great, but for me as SVN user it would be much better to get access to the sources using familiar tools, e.g. TortoiseSVN. Mainly because

Tagged with: , , , ,
Posted in Coding, PostgreSQL

Dump and restore of PostgreSQL: version compatibility FAQ

Many newbies are confused about how PostgreSQL dump and restore work. And even more questions appeared about version mismatches of the server itself and tools used. After fresh PostgresDAC release we’ve faced with the same questions. Utilities used for dump

Tagged with: , , ,
Posted in PostgresDAC, PostgreSQL

Development using Lazarus and PostgresDAC. Installation

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,

Tagged with: , , , ,
Posted in PostgresDAC

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.

Tagged with: , ,
Posted in Coding, PostgresDAC

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:

Tagged with: ,
Posted in PostgreSQL

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

Tagged with: ,
Posted in PostgreSQL
Map of wandering

Get every new post delivered to your Inbox.

Join 83 other followers