Tag: 9.1

  • Steps to install the PostgreSQL on windows

    Steps to install the PostgreSQL on windows

     

     

    You can get the PostGreSQL installable from the http://www.postgresql.org/download/ site.

    In the below step setup will create the super user PostGres for the database and service account.

    Un-check the stack builder if you don’t want to download any additional tools.

  • What is PostgreSQL?

    PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. PostgreSQL is open source database system which supports all the below 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

     

     

    License

    PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic