PostgreSQL 9.3 tidbits

Just came across an article that listed some of the cool new features of postgresql database. I've listed out some of those that I liked and thought might be useful...

• pg_isready - New command-line utility to test whether a server is ready to accept connections.

$ pg_isready -p 5432 -h localhost
localhost:5432 - accepting connections

• \watch - Allows convenient re-execution of queries. 

postgres=# SELECT datname, query, usename FROM pg_stat_activity ORDER BY query_start DESC LIMIT 1; \watch 60

• \conninfo - Displays current connection information

postgres=# \conninfo
You are connected to database "postgres" as user "postgres" via socket in "/tmp" at port "5432".




• \l - List Databases

postgres=# \l

                                  List of databases

        Name         |  Owner   | Encoding | Collate | Ctype |   Access privileges

---------------------+----------+----------+---------+-------+-----------------------

 arts_v6             | postgres | UTF8     | C       | C     |

 enact_recreate_test | postgres | UTF8     | C       | C     |

 postgres            | postgres | UTF8     | C       | C     |

 quarrysb_13_0_0     | postgres | UTF8     | C       | C     |

 template0           | postgres | UTF8     | C       | C     | =c/postgres          +

                     |          |          |         |       | postgres=CTc/postgres

 template1           | postgres | UTF8     | C       | C     | =c/postgres          +

                     |          |          |         |       | postgres=CTc/postgres

(6 rows)