Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Features

PostgreSQL supports a large part of the SQL standard and offers many modern features including the following:
1.SQL -structured query language
  • datatypes
  • language
  • constraints
  • operators
  • function
  • joins
  • subquery
  • views
  • synonym
  • sequence
2.PL/pgSQL - procedural postgre structured query language 
  • installing procedural language
  • structure of Pl/pgSQL
  • languages
  • cursors
  • exception
  • procedure
  • function
  • triggers 
3.architecture
  • fundamentals
4.installation
  • GUI mode
  • text mode
  • unattended mode
5.database
  • creating database
  • accessing a database
  • managing  roles,
  • managing schema, 
  • managing tablespace
  • fragmentaion
  • index
  • lock management
  • partition
  • job
6.backup and restore
  • dump
  • filesystem level backup
  • PITR
7.high availability
  • Warm Standby Replication (as of 8.3)
  • Streaming Replication (as of 9.0)
  • Hot Standby (as of 9.0) 
  • failover
  • Monitorin Standby
8.database activity
  • statistics collector
  • viewing locks
  • dynamic tracing
  • disk usage
  • disk full failure
  • write-ahead logging (WAL)
  • configuration
9.clinet interface
  • libpq -c library
  • large objects
  • ECPG -empedded sql in c
  • the information schema
10.Multiversion concurrency control (MVCC)

11.Postgresql Monitoring      
           




No comments:

Post a Comment