Posts

What is postgreSQL?

postgreSQL is an object-relational database management system(ORDBMS) based on postgres.It is an open-source product.It supports a large part of sql standards and offers many modern features. * complex queries * foreign keys * triggers * views * transactional integrity * multiversion concurrency control Also, postgreSQL can be extended by the user in many ways, for example by adding new * data types * functions * operators * aggregate functions * index methods * procedural languages There is a extension called postGIS to the postgreSQL. postGIS supports for geographical objects to the postgreSQL database, allowing it to be backend database for geographic information systems(GIS). And because of the liberal license, postgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic. How can we install postgresql in debian system..... Just search in your cache for postg

Postgresql - PostGIS

Postgresql is opensource product. There are good and bad things on it. Because if you are a programmer and you are working with web, I think postgresql is not good for back end database. Then you can use mysql for that purpose. But your going to working other stuff specially GIS stuff you can use postgresql. To add GIS capability to postgresql you have install postGIS in your machine... http://www.postgis.org/ And also it has well built server side procedural languages. To download postgresql latest version http://www.postgresql.org/ To download postgresql docs http://www.postgresql.org/docs/