Saturday, November 19, 2011

PostgreSQL Integer Array - Install Integer Array Module

I would like to start it by, How to initiate Integer array operation in PostgreSQL ?

For using Integer array in PostgreSQL 8.4 we have to install contrib package

Installing contrib package in Ubuntu.


apt-get install postgresql-contrib

Then you have to move to folder by the path given below,

cd /usr/share/postgresql/8.4/contrib/


Then execute the command given below.

psql -U {postgres_user} -d {db_name} -f _int.sql


Now the Integer array module is installed for your database.

If you changed your database in your application means you have install the module once again for that DB.

No comments:

Post a Comment