PostgreSQL : Java Glossary

by Roedy Green ©1996-2008 Canadian Mind Products
Go to : punctuation 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z (all)

A free SQL database. It has a number of advantages over MySQL.

PostGres is a mature product with its roots in Berkeley.
PostGres has many data types.
You can add your own data tapes by defining them with a little C code.
You can write triggers in Oracle stored procedure language PL/SQL or in other languages such as Java.
PostGres is highly compatible with Oracle. It handles triggers the same way.
PostGres does not crash under heavy loads.
PostGres has remote SSL access.
PostGres has PGADMIN3 for a graphical way of administration from a PC.
PostGres allows inheritance in the SQL definitions. E.g. a capitals row definition can be derived from a cities row definition.
PostGres uses multiversion concurrency control, rather than locks. Each transaction sees a snapshot of the database at a logical instant in time. Reading does not block writing and vice versa.

MySQL’s advantages are:

PostGreSQL Supported Types

Name	Aliases	Description
bigint	int8	signed eight-byte integer
bigserial	serial8	autoincrementing eight-byte integer
bit		fixed-length bit string
bit varying(n)	varbit(n)	variable-length bit string
boolean	bool	logical Boolean (true/false)
box		rectangular box in the plane
bytea		binary data
character varying(n)	varchar(n)	variable-length character string
character(n)	char(n)	fixed-length character string
cidr		IPv4 or IPv6 network address
circle		circle in the plane
date		calendar date (year, month, day)
double precision	float8	double precision floating-point number
inet		IPv4 or IPv6 host address
integer	int, int4	signed four-byte integer
interval(p)		time span
line		infinite line in the plane (not fully implemented)
lseg		line segment in the plane
macaddr		MAC address
money		currency amount
numeric [ (p, s) ]	decimal [ (p, s) ]	exact numeric with selectable precision
path		open and closed geometric path in the plane
point		geometric point in the plane
polygon		closed geometric path in the plane
real	float4	single precision floating-point number
smallint	int2	signed two-byte integer
serial	serial4	autoincrementing four-byte integer
text		variable-length character string
time [ (p) ] [ without time zone ]		time of day
time [ (p) ] with time zone	timetz	time of day, including time zone
timestamp [ (p) ] without time zone	timestamp	date and time
timestamp [ (p) ] [ with time zone ]	timestamptz	date and time, including time zone

	Please email your feedback for publication, errors, omissions, broken/redirected link reports and suggestions to improve this page to Roedy Green :
	Canadian Mind Products
	mindprod.com IP:[65.110.21.43]
	Your face IP:[38.103.63.18]	The information on this page is for non-military use only.
	You are visitor number 11,102.	Military use includes use by defence contractors.
	You can get a fresh copy of this page from:	or possibly from your local J: drive (Java virtual drive/Mindprod website mirror)
	http://mindprod.com/jgloss/postgresql.html	J:\mindprod\jgloss\postgresql.html