Tuesday, 16 September 2014

Useful Date Functions in PostgreSQL

›
Date Functions: ---------------------- 1) Now() in Transaction Block don't change the time,it will show the same as transaction ...
Tuesday, 15 July 2014

Deleting Duplicate values in PostgreSQL

›
dev=# select ctid,* from test;  ctid  | id | name -------+----+------  (0,1) |  1 | RC  (0,2) |  2 | RC  (0,3) |  1 | RC  (0,4) |  2 ...
2 comments:
Saturday, 8 February 2014

How to Rebuild Primary key constraints or Indexes in Postgresql 8.4 +

›
1)  Verified the two tables relations and check the data on those table.      If you required take table dump backup of these two tables....
1 comment:
Friday, 7 February 2014

How to get all databse schemas from Postgresql cluster

›
1)  Configure the dblink contrib module to the cluster.  And create the extension on all database. Postgres=# create extension dblink ;...
Thursday, 22 August 2013

How to Change System time and timezone in linux ( IST )

›
1. check current time . 2.change the date and time using below date command. [root@pgham postgresql-9.3beta2]# date -s "5 Jul 201...
Wednesday, 29 May 2013

Table Partitioning on PostgreSQL

›
Table Partitioning on PostgreSQL: +++++++++++++++++++++++ 1)We are using Inheritance consept here to achive partitioning tables. 2)And a...
Wednesday, 8 May 2013

Prepared Transactions in PostgreSQL 9.2

›
Prepared Transactions: PREPARE TRANSACTION prepares the current transaction for two-phase commit. After this command, the transaction i...
2 comments: