Blog Archives

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

Backward compatibility? Never heard of it!

Playing with fresh PostgreSQL 9.2beta2 I cannot find spclocation column of a system catalog pg_tablespace. First my thought was that I’m too tired. But then I found mentioning about this at pgsql-hackers by Magnus Hagander: And IIRC, we don’t actually

Tagged with: , , ,
Posted in PostgreSQL

PG 9.2beta2 installation on Windows XP fails? Don’t worry!

Shit happens guys. And sometimes PostgreSQL windows installer fails. Now I’m talking about EnterpriseDB One-Click Installer for PostgreSQL 9.2beta2 particularly. As for me, I got “An error occurred executing the Microsoft VC++ runtime installer” message. Strange. I have a holy

Tagged with: , ,
Posted in PostgreSQL

The tale of how PostgresDAC became the cross-platform component suite

As some probably know Delphi XE2 now have compilers for Win32, Win64, Mac and iOS. And as you probably guessed, we were inundated with questions from our customers about support for this zoo in our DACs. Frankly speaking this situation

Tagged with: , , , , ,
Posted in PostgresDAC, PostgreSQL

LibreOffice announces native support for PostgreSQL

Today I found out about new release of LibreOffice (version 3.5), which is now my choice instead of MS Office and it’s brother OpenOffice killed by Oracle. And the most pleasant surprise is PostgreSQL native support added in this minor

Tagged with: , , ,
Posted in PostgreSQL
Archives
Map of wandering
Follow

Get every new post delivered to your Inbox.

Join 73 other followers