postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

Yes, Can be given at the time of table creation or can be with alter table

Answer Question  Select Best Answer

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

Triggers for tables and rules for view

Answer Question  Select Best Answer

Why the updation and deletion is too slow in Greenplum as compared to Insertion?

postgresql

 Profile Answers by postgresql Questions by postgresql

• Jul 1st, 2010

Because of MVCC architecture of PostgreSQL

Answer Question  Select Best Answer

SriramKrishna

 Profile Answers by SriramKrishna Questions by SriramKrishna

• May 5th, 2007

OID are used for unique row identification in POSTGRESQL. For identifying specific physical rows with block and offset values in POSTGRESQL TIDs are used. The relationship between OID and TID exists in such a way that whenever a row is altered the corresponding TID also gets altered.

Answer Question  Select Best Answer

nehalshah

 Profile Answers by nehalshah Questions by nehalshah

• May 5th, 2007

PsqlODBC, OpenLink, Mac ODBC driver  are some of the generally and widely used ODBC drivers that are available for POSTGRESQL.

Answer Question  Select Best Answer

scott

 Profile Answers by scott Questions by scott

• Apr 9th, 2007

The Maximum size for a database in PostgreSQL is Unlimited. There is no restriction on the Maximum size for a database in PostgreSQL.

Answer Question  Select Best Answer