PostgreSQL is an open source object-relational database management system that can run on Linux, UNIX and Windows. It supports a wide variety of data types and includes programming interfaces for many languages. PostgreSQL offers user-defined types, inheritance rules, multi-version concurrency control and other features not found in other databases. It also generally performs faster than other databases and has a reputation for stability due to its rigorous testing process. Support is available through mailing lists and commercial support options.

What's hot

Similar to PostgreSQL.pptx

Recently uploaded

PostgreSQL.pptx

• 1.
  PostgreSQL
• 2.
  INTRODUCTION• PostgreSQL isan object-relational database managementsystem (ORDBMS).• PostgreSQL was developed by the PostgreSQL GlobalDevelopment Group.• PostgreSQL Global Development Group is a worldwideteam of volunteers, and thus PostgreSQL is not controlledby any corporation or any other private entity.• open source and free to use.
• 3.
  Features of PostgreSQL•Runs on all major operating systemsincluding Linux, UNIX and Windows.• Supports text, images, sounds, and video.• Includes programming interfaces for C /C++, Java, Perl, Python, Ruby, Tcl andOpen Database Connectivity (ODBC).• A table in PostgreSQL can be set to inherittheir characteristics from a “parent” table.
• 4.
  COMPARISON WITH OTHERDATABASESFeatures notin othersUser-defined typesInheritance rulesMulti-versionconcurrency controlto reduce lockcontentionPerformanceFaster for somethingsUsually +10%compared to otherdatabasesReliabilityStable code that hasminimum of bugsRelease has atleastone month of betatestingSupportMailing listsDirect access todevelopers, the userscommunity, manualand source codeCommercial perincident supportPriceFree for all useProprietary and opensource
• 5.
  TOOLS DESCRIPTIONpsql● Commandline tool.● Primary tool to manage PostgreSQL.pgAdmin ● Free and open source graphical user interface administration tool for PostgreSQL.phpPgAdmin● Web-based administration tool for PostgreSQL written in PHP. Based on phpMyAdmin tool.● Manages MySQL.OpenOffice.org Base.● Can be used as a front end tool to PostgreSQL.pgFouine● Log analyzer.● Creates reports from PostgreSQL log files.
• 6.
  pgAdminA graphical toolfor managing anddeveloping the databases.
• 7.
  Psql Console
• 8.
  Query Tool
• 9.
  DatatypesName Aliases Descriptionbigintint8 signed eight-byte integerbigserial serial8 autoincrementing eight-byte integerbit [ (n) ] fixed-length bit stringbit varying [ (n) ] varbit [ (n) ] variable-length bit stringboolean bool logical Boolean (true/false)box rectangular box on a planebytea binary data (“byte array”)
• 10.
  Name Aliases Descriptioncharacter[ (n) ] char [ (n) ] fixed-length character stringcharacter varying [ (n) ] varchar [ (n) ] variable-length character stringcidr IPv4 or IPv6 network addresscircle circle on a planedate calendar date (year, month, day)double precision float8 double precision floating-pointnumber (8 bytes)inet IPv4 or IPv6 host addressinteger int, int4 signed four-byte integerinterval [ fields ] [ (p) ] time spanjson textual JSON datajsonb binary JSON data, decomposedline infinite line on a planelseg line segment on a planemacaddr MAC (Media Access Control)addressmacaddr8 MAC (Media Access Control)address (EUI-64 format)
• 11.
  Name Aliases Descriptionpolygonclosed geometric path on a planereal float4 single precision floating-pointnumber (4 bytes)smallint int2 signed two-byte integersmallserial serial2 autoincrementing two-byte integerserial serial4 autoincrementing four-byte integertext variable-length character stringtime [ (p) ] [ without time zone ] time of day (no time zone)time [ (p) ] with time zone timetz time of day, including time zonetimestamp [ (p) ] [ without timezone ]date and time (no time zone)timestamp [ (p) ] with time zone timestamptz date and time, including time zonetsquery text search querytsvector text search documenttxid_snapshot user-level transaction ID snapshot(deprecated; see pg_snapshot)uuid universally unique identifierxml XML data