Postgresql - planet.postgresql.org - Planet PostgreSQL
General Information:
Latest News:
Dimitri Fontaine: Auditing Changes with Hstore 27 Aug 2013 | 08:35 pm
In a previous article about Trigger Parameters we have been using the extension hstore in order to compute some extra field in our records, where the fields used both for the computation and for stori...
Craig Ringer: Choosing a PostgreSQL text search method 27 Aug 2013 | 03:04 pm
(This article is written with reference to PostgreSQL 9.3. If you’re using a newer version please check to make sure any limitations described remain in place.) PostgreSQL offers several tools for se...
Selena Deckelmann: Fancy SQL Monday: format() instead of quote_*() 26 Aug 2013 | 09:29 pm
In the comments, Isaac pointed out that using format() dramatically increases the readability of SQL. I liked the look of his query, so I dug a little deeper. As of version 9.1 (first released in 201...
Ian Barwick: Living on the edge - 9.3 RC1 26 Aug 2013 | 08:40 pm
PostgreSQL 9.3 RC1 was released the other day, and despite the dire warnings I couldn't resist putting it on this server to try out some of the new functionality in live operation. Admittedly it's not...
Chris Travers: When to use SELECT * in PostgreSQL 26 Aug 2013 | 04:24 pm
In LedgerSMB we use a lot of queries which involve SELECT *. Many people consider SELECT * harmful but there are several cases where it is useful. Keep in mind we encapsulate the database behind an ...
Hans-Juergen Schoenig: Table bloat revisited: Making tables shrink 26 Aug 2013 | 03:40 pm
Many people are wondering why deleting data from a table in a PostgreSQL database does not shrink files on disk. You would expect storage consumption to go down when data is deleted. This is not alway...
Fabien Coelho: Turing Machine in SQL (4) 26 Aug 2013 | 11:01 am
In previous posts [1 2 3], I have presented different ways of implementing a Turing Machine (TM) in SQL with PostgreSQL. All three techniques rely on WITH RECURSIVE to iterate till the TM stops, so as...
Michael Paquier: Postgres module highlight: customize passwordcheck to secure your database 24 Aug 2013 | 04:31 pm
passwordcheck is a contrib module present in PostgreSQL core using a hook present in server code when creating or modifying a role with CREATE/ALTER ROLE/USER able to check a password. This hook is pr...
Valentine Gogichashvili: Real-time console based monitoring of PostgreSQL databases (pg_view) 24 Aug 2013 | 04:11 pm
In many cases, it is important to be able to keep your hand on the pulse of your database in real-time. For example when you are running a big migration task that can introduce some unexpected locks, ...
Raghavendra Rao: How to change all objects ownership in a particular schema in PostgreSQL ? 24 Aug 2013 | 03:04 pm
Few suggesion's here (Thanks), inspired me to compose a bash script for changing all object's (TABLES / SEQUENCES / VIEWS / FUNCTIONS / AGGREGATES / TYPES) ownership in a particular schema in one go. ...
