PostgreSQL or Postgres is a ORDBMS (Object Relational
Database Management System) and is developed by the PostgreSQL Global
Development Group.
Features
a.
PostgreSQL support ACID (Atomicity, Consistency,
Isolation and durability) properties.
b.
PostgreSQL is default for MacOS server
c.
PostgreSQL is cross platform, you can run on Linux,
FreeBSD, OpenBSD, and Windows.
d.
PostgreSQL support transactional capability
e.
PostgreSQL support materialized views, triggers,
foreign keys, indexes, functions and stored procedures.
f.
PostgreSQL is open source and free
g.
PostgreSQL support table inheritance. For example, I
can derive a table from a type.
create type employee_type as (id integer, firstname text, lastname
text);
create table employee of employee_type;
h.
PostgreSQL support function overloading
i.
PostgreSQL support multiversion concurrency control
(MVCC).
You can interact with PostgreSQL from variety of
languages like Java, Go, Python etc.,
What is
ORDBMS?
RDMS + Object oriented features
- Installing and setup PostgreSQL in Mac
- How to get all available datatypes?
- Create database
- Create table
- DESCRIBE table
- Insert data into table
- Get the data from table
- List all databases
- Drop database
- List all the tables
- Drop table
- Describe Table
- PostgreSQL sequences
No comments:
Post a Comment