PostgreSQL.pptx

PostgreSQL.pptx

• 1.
  PostgreSQL
• 2.
  INTRODUCTION • PostgreSQL isan object-relational database management system (ORDBMS). • PostgreSQL was developed by the PostgreSQL Global Development Group. • PostgreSQL Global Development Group is a worldwide team of volunteers, and thus PostgreSQL is not controlled by any corporation or any other private entity. • open source and free to use.
• 3.
  Features of PostgreSQL •Runs on all major operating systems including Linux, UNIX and Windows. • Supports text, images, sounds, and video. • Includes programming interfaces for C / C++, Java, Perl, Python, Ruby, Tcl and Open Database Connectivity (ODBC). • A table in PostgreSQL can be set to inherit their characteristics from a “parent” table.
• 4.
  COMPARISON WITH OTHERDATABASES Features not in others User-defined types Inheritance rules Multi-version concurrency control to reduce lock contention Performance Faster for some things Usually +10% compared to other databases Reliability Stable code that has minimum of bugs Release has atleast one month of beta testing Support Mailing lists Direct access to developers, the users community, manual and source code Commercial per incident support Price Free for all use Proprietary and open source
• 5.
  TOOLS DESCRIPTION psql ● 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.
  pgAdmin A graphical toolfor managing and developing the databases.
• 7.
  Psql Console
• 8.
  Query Tool
• 9.
  Datatypes Name Aliases Description bigintint8 signed eight-byte integer bigserial serial8 autoincrementing eight-byte integer bit [ (n) ] fixed-length bit string bit varying [ (n) ] varbit [ (n) ] variable-length bit string boolean bool logical Boolean (true/false) box rectangular box on a plane bytea binary data (“byte array”)
• 10.
  Name Aliases Description character[ (n) ] char [ (n) ] fixed-length character string character varying [ (n) ] varchar [ (n) ] variable-length character string cidr IPv4 or IPv6 network address circle circle on a plane date calendar date (year, month, day) double precision float8 double precision floating-point number (8 bytes) inet IPv4 or IPv6 host address integer int, int4 signed four-byte integer interval [ fields ] [ (p) ] time span json textual JSON data jsonb binary JSON data, decomposed line infinite line on a plane lseg line segment on a plane macaddr MAC (Media Access Control) address macaddr8 MAC (Media Access Control) address (EUI-64 format)
• 11.
  Name Aliases Description polygonclosed geometric path on a plane real float4 single precision floating-point number (4 bytes) smallint int2 signed two-byte integer smallserial serial2 autoincrementing two-byte integer serial serial4 autoincrementing four-byte integer text variable-length character string time [ (p) ] [ without time zone ] time of day (no time zone) time [ (p) ] with time zone timetz time of day, including time zone timestamp [ (p) ] [ without time zone ] date and time (no time zone) timestamp [ (p) ] with time zone timestamptz date and time, including time zone tsquery text search query tsvector text search document txid_snapshot user-level transaction ID snapshot (deprecated; see pg_snapshot) uuid universally unique identifier xml XML data