Postgres 9.3 feature highlight - \watch in psql

2013-05-02 05:01:04 +0000

psql is the native client of PostgreSQL widely used by application developers and database administrators on a daily-basis for common operations when interacting with a PostgreSQL server. With a full set of integrated functionalities, it is among the most popular (if not the number one) client applications in the Postgres community. If you are a Postgres nerd (highly possible if you are reading this page), you know that the feeling of discovering a new functionality in psql is close to the excitement you can have when opening a christmas present as you know that such a feature went though the strict community review process. The upcoming release 9.3 of Postgres is not an exception and brings a new useful command called \watch. This feature has been introduced by this commit:

Postgres 9.3 feature highlight - parallel pg_dump

2013-04-25 00:01:43 +0000

Among one of the many new features implemented in 9.3, pg_dump now offers the possibility to perform parallel dumps. This feature has been introduced by the commit below.

Postgres 9.3 feature highlight - JSON parsing functions

2013-04-17 16:30:29 +0000

Continuing on the coverage of new JSON features added in Postgres 9.3, and after writing about JSON data generation and JSON operators, let’s now focus on some new functions that can be used for the parsing of JSON data.

Postgres 9.3 feature highlight - JSON operators

2013-04-11 05:52:51 +0000

Postgres 9.3 is going to be a great release for JSON data type. After having a look at the new functions for data generation, let’s look at the new JSON features that the commit below brings.

Postgres 9.3 feature highlight - JSON data generation

2013-04-03 14:29:21 +0000

Postgres 9.2 has introduced JSON as a server data type. At this point, the data was simply stored on server side with integrated wrappers checking that data had a correct JSON format. It was a good first step in order to store directly JSON data on server side but core features in 9.2 have its limitations in terms of JSON data manipulation and transformation.

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Next »

Michael Paquier - PostgreSQL committer

Postgres 9.3 feature highlight - \watch in psql

Postgres 9.3 feature highlight - parallel pg_dump

Postgres 9.3 feature highlight - JSON parsing functions

Postgres 9.3 feature highlight - JSON operators

Postgres 9.3 feature highlight - JSON data generation

Search

Social

RSS Feeds

Sponsor