|
|
|
| |
| Features |
| |
ANSI SQL 89, 92 and 99 syntax
Transactions 100% A.C.I.D compliant: atomicity, consistency, isolation, durability. Full Commit and Rollback support
Isolation levels: Serializable / Read Committed
Online Backup: higher safety and availability of your data
Data Types: numeric, decimal, smallint, integer, bigint, real, double, serial, char, varchar, bit, text, date, time, timestamp, interval, boolean, network address, geometric types and much more
New data types may also be created by users
Storage of BLOBs (Binary Large Objects), including text, audio, photos and video
Referential Integrity: uses CREATE TABLE...FOREIGN KEY, cascade, restrict, set default, set null
Aggregations: full support to GROUP BY and aggregate functions like COUNT, SUM, AVG, MIN, MAX, STDDEV and VARIANCE. New aggregate functions may be created as needed
Joins: implements all types: cross, inner, outer, left, right, full, natural
Views: supports standard ANSI and also updatable views
User defined functions (Stored Procedures) that can be written in many server supported languages: C, SQL, PL/pgSQL (similar to Oracle PL/SQL), TCL, Perl, Python and Ruby
Programming languages and interfaces: Perl, Python, Zope, PHP, TCL/TK, ODBC, JDBC, C/C++, Embedded SQL, Delphi/Kylix/Pascal, VB, ASP, Java
Functions and operators library with several pre-installed functions (math, date/time, string, geometric, formating, etc.)
Triggers: trigger functions may be defined in any server supported language like C or PL/pgSQL
Exclusive Multi-version concurrency control ( MVCC ) system, for high demanding concurrent applications. In this unique mechanism readers do not block writers and writers do not block readers, reducing ( sometimes eliminating ) concurrent transactions contention and deadlocks
Temporary tables, that are dropped automatically at the end of a session
Standard user/group security model. Access to the database server may be limited by user, host or database
Database and Table size is virtually unlimited. Unlimited records and indexes per table |
| |
| |
|
|
|
|
Home :: PostgreSQL
Search
info@dbexperts.net