Functions

	Name	Owner	Comment
	abbrev(inet)	postgres	abbreviated display of inet value
	abbrev(cidr)	postgres	abbreviated display of cidr value
	abs(real)	postgres	absolute value
	abs(double precision)	postgres	absolute value
	abs(bigint)	postgres	absolute value
	abs(numeric)	postgres	absolute value
	abs(integer)	postgres	absolute value
	abs(smallint)	postgres	absolute value
	abstime(timestamp with time zone)	postgres	convert timestamp with time zone to abstime
	abstime(timestamp without time zone)	postgres	convert timestamp to abstime
	abstimeeq(abstime, abstime)	postgres	equal
	abstimege(abstime, abstime)	postgres	greater-than-or-equal
	abstimegt(abstime, abstime)	postgres	greater-than
	abstimein(cstring)	postgres	I/O
	abstimele(abstime, abstime)	postgres	less-than-or-equal
	abstimelt(abstime, abstime)	postgres	less-than
	abstimene(abstime, abstime)	postgres	not equal
	abstimeout(abstime)	postgres	I/O
	abstimerecv(internal)	postgres	I/O
	abstimesend(abstime)	postgres	I/O
	aclcontains(aclitem)	postgres	ACL contains item?
	aclinsert(aclitem)	postgres	add/update ACL item
	aclitemeq(aclitem, aclitem)	postgres	equality operator for ACL items
	aclitemin(cstring)	postgres	I/O
	aclitemout(aclitem)	postgres	I/O
	aclremove(aclitem)	postgres	remove ACL item
	acos(double precision)	postgres	arccosine
	age(timestamp without time zone)	postgres	date difference from today preserving months and years
	age(timestamp with time zone)	postgres	date difference from today preserving months and years
	age(timestamp without time zone, timestamp without time zone)	postgres	date difference preserving months and years
	age(timestamp with time zone, timestamp with time zone)	postgres	date difference preserving months and years
	age(xid)	postgres	age of a transaction ID, in transactions before current transaction
	any_in(cstring)	postgres	I/O
	any_out("any")	postgres	I/O
	anyarray_in(cstring)	postgres	I/O
	anyarray_out(anyarray)	postgres	I/O
	anyarray_recv(internal)	postgres	I/O
	anyarray_send(anyarray)	postgres	I/O
	anyelement_in(cstring)	postgres	I/O
	anyelement_out(anyelement)	postgres	I/O
	area(box)	postgres	box area
	area(circle)	postgres	area of circle
	area(path)	postgres	area of a closed path
	areajoinsel(internal, oid, internal, smallint)	postgres	join selectivity for area-comparison operators
	areasel(internal, oid, internal, integer)	postgres	restriction selectivity for area-comparison operators
	array_append(anyarray, anyelement)	postgres	append element onto end of array
	array_cat(anyarray, anyarray)	postgres	concatenate two arrays
	array_coerce(anyarray)	postgres	coerce array to another array type
	array_dims(anyarray)	postgres	array dimensions
	array_eq(anyarray, anyarray)	postgres	array equal
	array_ge(anyarray, anyarray)	postgres	array greater than or equal
	array_gt(anyarray, anyarray)	postgres	array greater than
	array_in(cstring, oid, integer)	postgres	I/O
	array_larger(anyarray, anyarray)	postgres	larger of two
	array_le(anyarray, anyarray)	postgres	array less than or equal
	array_length_coerce(anyarray, integer, boolean)	postgres	adjust any array to new element typmod
	array_lower(anyarray, integer)	postgres	array lower dimension
	array_lt(anyarray, anyarray)	postgres	array less than
	array_ne(anyarray, anyarray)	postgres	array not equal
	array_out(anyarray)	postgres	I/O
	array_prepend(anyelement, anyarray)	postgres	prepend element onto front of array
	array_recv(internal, oid, integer)	postgres	I/O
	array_send(anyarray)	postgres	I/O
	array_smaller(anyarray, anyarray)	postgres	smaller of two
	array_to_string(anyarray, text)	postgres	concatenate array elements, using delimiter, into text
	array_type_length_coerce(anyarray, integer, boolean)	postgres	coerce array to another type and adjust element typmod
	array_upper(anyarray, integer)	postgres	array upper dimension
	arraycontained(anyarray, anyarray)	postgres	is contained by
	arraycontains(anyarray, anyarray)	postgres	contains
	arrayoverlap(anyarray, anyarray)	postgres	overlaps
	ascii(text)	postgres	convert first char to int4
	ascii_to_mic(integer, integer, cstring, internal, integer)	postgres
	ascii_to_utf8(integer, integer, cstring, internal, integer)	postgres
	asin(double precision)	postgres	arcsine
	atan(double precision)	postgres	arctangent
	atan2(double precision, double precision)	postgres	arctangent, two arguments
	big5_to_euc_tw(integer, integer, cstring, internal, integer)	postgres
	big5_to_mic(integer, integer, cstring, internal, integer)	postgres
	big5_to_utf8(integer, integer, cstring, internal, integer)	postgres
	bit(integer, integer)	postgres	int4 to bitstring
	bit(bigint, integer)	postgres	int8 to bitstring
	bit(bit, integer, boolean)	postgres	adjust bit() to typmod length
	bit_in(cstring, oid, integer)	postgres	I/O
	bit_length(bit)	postgres	length in bits
	bit_length(bytea)	postgres	length in bits
	bit_length(text)	postgres	length in bits
	bit_out(bit)	postgres	I/O
	bit_recv(internal, oid, integer)	postgres	I/O
	bit_send(bit)	postgres	I/O
	bitand(bit, bit)	postgres	bitwise and
	bitcat(bit, bit)	postgres	bitwise concatenation
	bitcmp(bit, bit)	postgres	compare
	biteq(bit, bit)	postgres	equal
	bitge(bit, bit)	postgres	greater than or equal
	bitgt(bit, bit)	postgres	greater than
	bitle(bit, bit)	postgres	less than or equal
	bitlt(bit, bit)	postgres	less than
	bitne(bit, bit)	postgres	not equal
	bitnot(bit)	postgres	bitwise not
	bitor(bit, bit)	postgres	bitwise or
	bitshiftleft(bit, integer)	postgres	bitwise left shift
	bitshiftright(bit, integer)	postgres	bitwise right shift
	bitxor(bit, bit)	postgres	bitwise exclusive or
	bool(integer)	postgres	convert int4 to boolean
	booland_statefunc(boolean, boolean)	postgres	boolean-and aggregate transition function
	booleq(boolean, boolean)	postgres	equal
	boolge(boolean, boolean)	postgres	greater-than-or-equal
	boolgt(boolean, boolean)	postgres	greater-than
	boolin(cstring)	postgres	I/O
	boolle(boolean, boolean)	postgres	less-than-or-equal
	boollt(boolean, boolean)	postgres	less-than
	boolne(boolean, boolean)	postgres	not equal
	boolor_statefunc(boolean, boolean)	postgres	boolean-or aggregate transition function
	boolout(boolean)	postgres	I/O
	boolrecv(internal)	postgres	I/O
	boolsend(boolean)	postgres	I/O
	box(point, point)	postgres	convert points to box
	box(polygon)	postgres	convert polygon to bounding box
	box(circle)	postgres	convert circle to box
	box_above(box, box)	postgres	is above
	box_above_eq(box, box)	postgres	is above (allows touching)
	box_add(box, point)	postgres	add point to box (translate)
	box_below(box, box)	postgres	is below
	box_below_eq(box, box)	postgres	is below (allows touching)
	box_center(box)	postgres	center of
	box_contain(box, box)	postgres	contains?
	box_contained(box, box)	postgres	is contained by?
	box_distance(box, box)	postgres	distance between boxes
	box_div(box, point)	postgres	divide box by point (scale)
	box_eq(box, box)	postgres	equal by area
	box_ge(box, box)	postgres	greater-than-or-equal by area
	box_gt(box, box)	postgres	greater-than by area
	box_in(cstring)	postgres	I/O
	box_intersect(box, box)	postgres	box intersection (another box)
	box_le(box, box)	postgres	less-than-or-equal by area
	box_left(box, box)	postgres	is left of
	box_lt(box, box)	postgres	less-than by area
	box_mul(box, point)	postgres	multiply box by point (scale)
	box_out(box)	postgres	I/O
	box_overabove(box, box)	postgres	overlaps or is above
	box_overbelow(box, box)	postgres	overlaps or is below
	box_overlap(box, box)	postgres	overlaps
	box_overleft(box, box)	postgres	overlaps or is left of
	box_overright(box, box)	postgres	overlaps or is right of
	box_recv(internal)	postgres	I/O
	box_right(box, box)	postgres	is right of
	box_same(box, box)	postgres	same as?
	box_send(box)	postgres	I/O
	box_sub(box, point)	postgres	subtract point from box (translate)
	bpchar(name)	postgres	convert name to char(n)
	bpchar("char")	postgres	convert char to char()
	bpchar(character, integer, boolean)	postgres	adjust char() to typmod length
	bpchar_larger(character, character)	postgres	larger of two
	bpchar_pattern_eq(character, character)	postgres
	bpchar_pattern_ge(character, character)	postgres
	bpchar_pattern_gt(character, character)	postgres
	bpchar_pattern_le(character, character)	postgres
	bpchar_pattern_lt(character, character)	postgres
	bpchar_pattern_ne(character, character)	postgres
	bpchar_smaller(character, character)	postgres	smaller of two
	bpcharcmp(character, character)	postgres	less-equal-greater
	bpchareq(character, character)	postgres	equal
	bpcharge(character, character)	postgres	greater-than-or-equal
	bpchargt(character, character)	postgres	greater-than
	bpchariclike(character, text)	postgres	matches LIKE expression, case-insensitive
	bpcharicnlike(character, text)	postgres	does not match LIKE expression, case-insensitive
	bpcharicregexeq(character, text)	postgres	matches regex., case-insensitive
	bpcharicregexne(character, text)	postgres	does not match regex., case-insensitive
	bpcharin(cstring, oid, integer)	postgres	I/O
	bpcharle(character, character)	postgres	less-than-or-equal
	bpcharlike(character, text)	postgres	matches LIKE expression
	bpcharlt(character, character)	postgres	less-than
	bpcharne(character, character)	postgres	not equal
	bpcharnlike(character, text)	postgres	does not match LIKE expression
	bpcharout(character)	postgres	I/O
	bpcharrecv(internal, oid, integer)	postgres	I/O
	bpcharregexeq(character, text)	postgres	matches regex., case-sensitive
	bpcharregexne(character, text)	postgres	does not match regex., case-sensitive
	bpcharsend(character)	postgres	I/O
	broadcast(inet)	postgres	broadcast address of network
	btabstimecmp(abstime, abstime)	postgres	btree less-equal-greater
	btarraycmp(anyarray, anyarray)	postgres	btree less-equal-greater
	btbeginscan(internal, internal, internal)	postgres	btree(internal)
	btboolcmp(boolean, boolean)	postgres	btree less-equal-greater
	btbpchar_pattern_cmp(character, character)	postgres
	btbuild(internal, internal, internal)	postgres	btree(internal)
	btbulkdelete(internal, internal, internal, internal)	postgres	btree(internal)
	btcharcmp("char", "char")	postgres	btree less-equal-greater
	btcostestimate(internal, internal, internal, internal, internal, internal, internal, internal)	postgres	btree(internal)
	btendscan(internal)	postgres	btree(internal)
	btfloat48cmp(real, double precision)	postgres
	btfloat4cmp(real, real)	postgres	btree less-equal-greater
	btfloat84cmp(double precision, real)	postgres
	btfloat8cmp(double precision, double precision)	postgres	btree less-equal-greater
	btgetmulti(internal, internal, internal, internal)	postgres	btree(internal)
	btgettuple(internal, internal)	postgres	btree(internal)
	btinsert(internal, internal, internal, internal, internal, internal)	postgres	btree(internal)
	btint24cmp(smallint, integer)	postgres
	btint28cmp(smallint, bigint)	postgres
	btint2cmp(smallint, smallint)	postgres	btree less-equal-greater
	btint42cmp(integer, smallint)	postgres
	btint48cmp(integer, bigint)	postgres
	btint4cmp(integer, integer)	postgres	btree less-equal-greater
	btint82cmp(bigint, smallint)	postgres
	btint84cmp(bigint, integer)	postgres
	btint8cmp(bigint, bigint)	postgres	btree less-equal-greater
	btmarkpos(internal)	postgres	btree(internal)
	btname_pattern_cmp(name, name)	postgres
	btnamecmp(name, name)	postgres	btree less-equal-greater
	btoidcmp(oid, oid)	postgres	btree less-equal-greater
	btoidvectorcmp(oidvector, oidvector)	postgres	btree less-equal-greater
	btoptions(boolean)	postgres	btree(internal)
	btreltimecmp(reltime, reltime)	postgres	btree less-equal-greater
	btrescan(internal, internal)	postgres	btree(internal)
	btrestrpos(internal)	postgres	btree(internal)
	btrim(text, text)	postgres	trim selected characters from both ends of string
	btrim(text)	postgres	trim spaces from both ends of string
	btrim(bytea, bytea)	postgres	trim both ends of string
	bttext_pattern_cmp(text, text)	postgres
	bttextcmp(text, text)	postgres	btree less-equal-greater
	bttidcmp(tid, tid)	postgres	btree less-equal-greater
	bttintervalcmp(tinterval, tinterval)	postgres	btree less-equal-greater
	btvacuumcleanup(internal, internal)	postgres	btree(internal)
	byteacat(bytea, bytea)	postgres	concatenate
	byteacmp(bytea, bytea)	postgres	less-equal-greater
	byteaeq(bytea, bytea)	postgres	equal
	byteage(bytea, bytea)	postgres	greater-than-or-equal
	byteagt(bytea, bytea)	postgres	greater-than
	byteain(cstring)	postgres	I/O
	byteale(bytea, bytea)	postgres	less-than-or-equal
	bytealike(bytea, bytea)	postgres	matches LIKE expression
	bytealt(bytea, bytea)	postgres	less-than
	byteane(bytea, bytea)	postgres	not equal
	byteanlike(bytea, bytea)	postgres	does not match LIKE expression
	byteaout(bytea)	postgres	I/O
	bytearecv(internal)	postgres	I/O
	byteasend(bytea)	postgres	I/O
	cash_cmp(money, money)	postgres	btree less-equal-greater
	cash_div_flt4(money, real)	postgres	divide
	cash_div_flt8(money, double precision)	postgres	divide
	cash_div_int2(money, smallint)	postgres	divide
	cash_div_int4(money, integer)	postgres	divide
	cash_eq(money, money)	postgres	equal
	cash_ge(money, money)	postgres	greater-than-or-equal
	cash_gt(money, money)	postgres	greater-than
	cash_in(cstring)	postgres	I/O
	cash_le(money, money)	postgres	less-than-or-equal
	cash_lt(money, money)	postgres	less-than
	cash_mi(money, money)	postgres	subtract
	cash_mul_flt4(money, real)	postgres	multiply
	cash_mul_flt8(money, double precision)	postgres	multiply
	cash_mul_int2(money, smallint)	postgres	multiply
	cash_mul_int4(money, integer)	postgres	multiply
	cash_ne(money, money)	postgres	not equal
	cash_out(money)	postgres	I/O
	cash_pl(money, money)	postgres	add
	cash_recv(internal)	postgres	I/O
	cash_send(money)	postgres	I/O
	cash_words(money)	postgres	output amount as words
	cashlarger(money, money)	postgres	larger of two
	cashsmaller(money, money)	postgres	smaller of two
	cbrt(double precision)	postgres	cube root
	ceil(double precision)	postgres	smallest integer >= value
	ceil(numeric)	postgres	smallest integer >= value
	ceiling(double precision)	postgres	smallest integer >= value
	ceiling(numeric)	postgres	smallest integer >= value
	center(box)	postgres	center of
	center(circle)	postgres	center of
	char(integer)	postgres	convert int4 to char
	char(text)	postgres	convert text to char
	char_length(text)	postgres	character length
	char_length(character)	postgres	character length
	character_length(character)	postgres	character length
	character_length(text)	postgres	character length
	chareq("char", "char")	postgres	equal
	charge("char", "char")	postgres	greater-than-or-equal
	chargt("char", "char")	postgres	greater-than
	charin(cstring)	postgres	I/O
	charle("char", "char")	postgres	less-than-or-equal
	charlt("char", "char")	postgres	less-than
	charne("char", "char")	postgres	not equal
	charout("char")	postgres	I/O
	charrecv(internal)	postgres	I/O
	charsend("char")	postgres	I/O
	chr(integer)	postgres	convert int4 to char
	cideq(cid, cid)	postgres	equal
	cidin(cstring)	postgres	I/O
	cidout(cid)	postgres	I/O
	cidr(text)	postgres	text to cidr
	cidr(inet)	postgres	coerce inet to cidr
	cidr_in(cstring)	postgres	I/O
	cidr_out(cidr)	postgres	I/O
	cidr_recv(internal)	postgres	I/O
	cidr_send(cidr)	postgres	I/O
	cidrecv(internal)	postgres	I/O
	cidsend(cid)	postgres	I/O
	circle(point, double precision)	postgres	convert point and radius to circle
	circle(polygon)	postgres	convert polygon to circle
	circle(box)	postgres	convert box to circle
	circle_above(circle, circle)	postgres	is above
	circle_add_pt(circle, point)	postgres	add
	circle_below(circle, circle)	postgres	is below
	circle_center(circle)	postgres	center of
	circle_contain(circle, circle)	postgres	contains?
	circle_contain_pt(circle, point)	postgres	circle contains point?
	circle_contained(circle, circle)	postgres	is contained by?
	circle_distance(circle, circle)	postgres	distance between
	circle_div_pt(circle, point)	postgres	divide
	circle_eq(circle, circle)	postgres	equal by area
	circle_ge(circle, circle)	postgres	greater-than-or-equal by area
	circle_gt(circle, circle)	postgres	greater-than by area
	circle_in(cstring)	postgres	I/O
	circle_le(circle, circle)	postgres	less-than-or-equal by area
	circle_left(circle, circle)	postgres	is left of
	circle_lt(circle, circle)	postgres	less-than by area
	circle_mul_pt(circle, point)	postgres	multiply
	circle_ne(circle, circle)	postgres	not equal by area
	circle_out(circle)	postgres	I/O
	circle_overabove(circle, circle)	postgres	overlaps or is above
	circle_overbelow(circle, circle)	postgres	overlaps or is below
	circle_overlap(circle, circle)	postgres	overlaps
	circle_overleft(circle, circle)	postgres	overlaps or is left of
	circle_overright(circle, circle)	postgres	overlaps or is right of
	circle_recv(internal)	postgres	I/O
	circle_right(circle, circle)	postgres	is right of
	circle_same(circle, circle)	postgres	same as?
	circle_send(circle)	postgres	I/O
	circle_sub_pt(circle, point)	postgres	subtract
	clock_timestamp()	postgres	current clock time
	close_lb(line, box)	postgres	closest point to line on box
	close_ls(line, lseg)	postgres	closest point to line on line segment
	close_lseg(lseg, lseg)	postgres	closest point to line segment on line segment
	close_pb(point, box)	postgres	closest point on box
	close_pl(point, line)	postgres	closest point on line
	close_ps(point, lseg)	postgres	closest point on line segment
	close_sb(lseg, box)	postgres	closest point to line segment on box
	close_sl(lseg, line)	postgres	closest point to line segment on line
	col_description(oid, integer)	postgres	get description for table column
	contjoinsel(internal, oid, internal, smallint)	postgres	join selectivity for containment comparison operators
	contsel(internal, oid, internal, integer)	postgres	restriction selectivity for containment comparison operators
	convert(text, name, name)	postgres	convert string with specified encoding names
	convert(text, name)	postgres	convert string with specified destination encoding name
	convert_using(text, text)	postgres	convert string with specified conversion name
	cos(double precision)	postgres	cosine
	cot(double precision)	postgres	cotangent
	cstring_in(cstring)	postgres	I/O
	cstring_out(cstring)	postgres	I/O
	cstring_recv(internal)	postgres	I/O
	cstring_send(cstring)	postgres	I/O
	current_database()	postgres	returns the current database
	current_schema()	postgres	current schema name
	current_schemas(boolean)	postgres	current schema search list
	current_setting(text)	postgres	SHOW X as a function
	current_user()	postgres	current user name
	currtid(oid, tid)	postgres	latest tid of a tuple
	currtid2(text, tid)	postgres	latest tid of a tuple
	currval(regclass)	postgres	sequence current value
	date(text)	postgres	convert text to date
	date(abstime)	postgres	convert abstime to date
	date(timestamp with time zone)	postgres	convert timestamp with time zone to date
	date(timestamp without time zone)	postgres	convert timestamp to date
	date_cmp(date, date)	postgres	less-equal-greater
	date_cmp_timestamp(date, timestamp without time zone)	postgres	less-equal-greater
	date_cmp_timestamptz(date, timestamp with time zone)	postgres	less-equal-greater
	date_eq(date, date)	postgres	equal
	date_eq_timestamp(date, timestamp without time zone)	postgres	equal
	date_eq_timestamptz(date, timestamp with time zone)	postgres	equal
	date_ge(date, date)	postgres	greater-than-or-equal
	date_ge_timestamp(date, timestamp without time zone)	postgres	greater-than-or-equal
	date_ge_timestamptz(date, timestamp with time zone)	postgres	greater-than-or-equal
	date_gt(date, date)	postgres	greater-than
	date_gt_timestamp(date, timestamp without time zone)	postgres	greater-than
	date_gt_timestamptz(date, timestamp with time zone)	postgres	greater-than
	date_in(cstring)	postgres	I/O
	date_larger(date, date)	postgres	larger of two
	date_le(date, date)	postgres	less-than-or-equal
	date_le_timestamp(date, timestamp without time zone)	postgres	less-than-or-equal
	date_le_timestamptz(date, timestamp with time zone)	postgres	less-than-or-equal
	date_lt(date, date)	postgres	less-than
	date_lt_timestamp(date, timestamp without time zone)	postgres	less-than
	date_lt_timestamptz(date, timestamp with time zone)	postgres	less-than
	date_mi(date, date)	postgres	subtract
	date_mi_interval(date, interval)	postgres	subtract
	date_mii(date, integer)	postgres	subtract
	date_ne(date, date)	postgres	not equal
	date_ne_timestamp(date, timestamp without time zone)	postgres	not equal
	date_ne_timestamptz(date, timestamp with time zone)	postgres	not equal
	date_out(date)	postgres	I/O
	date_part(text, abstime)	postgres	extract field from abstime
	date_part(text, interval)	postgres	extract field from interval
	date_part(text, timestamp with time zone)	postgres	extract field from timestamp with time zone
	date_part(text, time with time zone)	postgres	extract field from time with time zone
	date_part(text, time without time zone)	postgres	extract field from time
	date_part(text, date)	postgres	extract field from date
	date_part(text, reltime)	postgres	extract field from reltime
	date_part(text, timestamp without time zone)	postgres	extract field from timestamp
	date_pl_interval(date, interval)	postgres	add
	date_pli(date, integer)	postgres	add
	date_recv(internal)	postgres	I/O
	date_send(date)	postgres	I/O
	date_smaller(date, date)	postgres	smaller of two
	date_trunc(text, interval)	postgres	truncate interval to specified units
	date_trunc(text, timestamp with time zone)	postgres	truncate timestamp with time zone to specified units
	date_trunc(text, timestamp without time zone)	postgres	truncate timestamp to specified units
	datetime_pl(date, time without time zone)	postgres	convert date and time to timestamp
	datetimetz_pl(date, time with time zone)	postgres	convert date and time with time zone to timestamp with time zone
	dcbrt(double precision)	postgres	cube root
	decode(text, text)	postgres	Convert ascii-encoded text string into bytea value
	degrees(double precision)	postgres	radians to degrees
	dexp(double precision)	postgres	natural exponential (e^x)
	diagonal(box)	postgres	box diagonal
	diameter(circle)	postgres	diameter of circle
	dist_cpoly(circle, polygon)	postgres	distance between
	dist_lb(line, box)	postgres	distance between line and box
	dist_pb(point, box)	postgres	distance between point and box
	dist_pc(point, circle)	postgres	distance between point and circle
	dist_pl(point, line)	postgres	distance between point and line
	dist_ppath(point, path)	postgres	distance between point and path
	dist_ps(point, lseg)	postgres	distance between
	dist_sb(lseg, box)	postgres	distance between segment and box
	dist_sl(lseg, line)	postgres	distance between lseg and line
	dlog1(double precision)	postgres	natural logarithm
	dlog10(double precision)	postgres	base 10 logarithm
	domain_in(cstring, oid, integer)	postgres	I/O
	domain_recv(internal, oid, integer)	postgres	I/O
	dpow(double precision, double precision)	postgres	exponentiation (x^y)
	dround(double precision)	postgres	round to nearest integer
	dsqrt(double precision)	postgres	square root
	dtrunc(double precision)	postgres	truncate to integer
	encode(bytea, text)	postgres	Convert bytea value into some ascii-only text string
	eqjoinsel(internal, oid, internal, smallint)	postgres	join selectivity of = and related operators
	eqsel(internal, oid, internal, integer)	postgres	restriction selectivity of = and related operators
	euc_cn_to_mic(integer, integer, cstring, internal, integer)	postgres
	euc_cn_to_utf8(integer, integer, cstring, internal, integer)	postgres
	euc_jp_to_mic(integer, integer, cstring, internal, integer)	postgres
	euc_jp_to_sjis(integer, integer, cstring, internal, integer)	postgres
	euc_jp_to_utf8(integer, integer, cstring, internal, integer)	postgres
	euc_kr_to_mic(integer, integer, cstring, internal, integer)	postgres
	euc_kr_to_utf8(integer, integer, cstring, internal, integer)	postgres
	euc_tw_to_big5(integer, integer, cstring, internal, integer)	postgres
	euc_tw_to_mic(integer, integer, cstring, internal, integer)	postgres
	euc_tw_to_utf8(integer, integer, cstring, internal, integer)	postgres
	exp(double precision)	postgres	exponential
	exp(numeric)	postgres	e raised to the power of n
	factorial(bigint)	postgres	factorial
	family(inet)	postgres	address family (4 for IPv4, 6 for IPv6)
	float4(integer)	postgres	convert int4 to float4
	float4(smallint)	postgres	convert int2 to float4
	float4(double precision)	postgres	convert float8 to float4
	float4(text)	postgres	convert text to float4
	float4(numeric)	postgres	(internal)
	float4(bigint)	postgres	convert int8 to float4
	float48div(real, double precision)	postgres	divide
	float48eq(real, double precision)	postgres	equal
	float48ge(real, double precision)	postgres	greater-than-or-equal
	float48gt(real, double precision)	postgres	greater-than
	float48le(real, double precision)	postgres	less-than-or-equal
	float48lt(real, double precision)	postgres	less-than
	float48mi(real, double precision)	postgres	subtract
	float48mul(real, double precision)	postgres	multiply
	float48ne(real, double precision)	postgres	not equal
	float48pl(real, double precision)	postgres	add
	float4_accum(real)	postgres	aggregate transition function
	float4abs(real)	postgres	absolute value
	float4div(real, real)	postgres	divide
	float4eq(real, real)	postgres	equal
	float4ge(real, real)	postgres	greater-than-or-equal
	float4gt(real, real)	postgres	greater-than
	float4in(cstring)	postgres	I/O
	float4larger(real, real)	postgres	larger of two
	float4le(real, real)	postgres	less-than-or-equal
	float4lt(real, real)	postgres	less-than
	float4mi(real, real)	postgres	subtract
	float4mul(real, real)	postgres	multiply
	float4ne(real, real)	postgres	not equal
	float4out(real)	postgres	I/O
	float4pl(real, real)	postgres	add
	float4recv(internal)	postgres	I/O
	float4send(real)	postgres	I/O
	float4smaller(real, real)	postgres	smaller of two
	float4um(real)	postgres	negate
	float4up(real)	postgres	unary plus
	float8(numeric)	postgres	(internal)
	float8(real)	postgres	convert float4 to float8
	float8(text)	postgres	convert text to float8
	float8(bigint)	postgres	convert int8 to float8
	float8(smallint)	postgres	convert int2 to float8
	float8(integer)	postgres	convert int4 to float8
	float84div(double precision, real)	postgres	divide
	float84eq(double precision, real)	postgres	equal
	float84ge(double precision, real)	postgres	greater-than-or-equal
	float84gt(double precision, real)	postgres	greater-than
	float84le(double precision, real)	postgres	less-than-or-equal
	float84lt(double precision, real)	postgres	less-than
	float84mi(double precision, real)	postgres	subtract
	float84mul(double precision, real)	postgres	multiply
	float84ne(double precision, real)	postgres	not equal
	float84pl(double precision, real)	postgres	add
	float8_accum(double precision)	postgres	aggregate transition function
	float8_avg()	postgres	AVG aggregate final function
	float8_corr()	postgres	CORR(double, double) aggregate final function
	float8_covar_pop()	postgres	COVAR_POP(double, double) aggregate final function
	float8_covar_samp()	postgres	COVAR_SAMP(double, double) aggregate final function
	float8_regr_accum(double precision, double precision)	postgres	REGR_...(double, double) transition function
	float8_regr_avgx()	postgres	REGR_AVGX(double, double) aggregate final function
	float8_regr_avgy()	postgres	REGR_AVGY(double, double) aggregate final function
	float8_regr_intercept()	postgres	REGR_INTERCEPT(double, double) aggregate final function
	float8_regr_r2()	postgres	REGR_R2(double, double) aggregate final function
	float8_regr_slope()	postgres	REGR_SLOPE(double, double) aggregate final function
	float8_regr_sxx()	postgres	REGR_SXX(double, double) aggregate final function
	float8_regr_sxy()	postgres	REGR_SXY(double, double) aggregate final function
	float8_regr_syy()	postgres	REGR_SYY(double, double) aggregate final function
	float8_stddev_pop()	postgres	STDDEV_POP aggregate final function
	float8_stddev_samp()	postgres	STDDEV_SAMP aggregate final function
	float8_var_pop()	postgres	VAR_POP aggregate final function
	float8_var_samp()	postgres	VAR_SAMP aggregate final function
	float8abs(double precision)	postgres	absolute value
	float8div(double precision, double precision)	postgres	divide
	float8eq(double precision, double precision)	postgres	equal
	float8ge(double precision, double precision)	postgres	greater-than-or-equal
	float8gt(double precision, double precision)	postgres	greater-than
	float8in(cstring)	postgres	I/O
	float8larger(double precision, double precision)	postgres	larger of two
	float8le(double precision, double precision)	postgres	less-than-or-equal
	float8lt(double precision, double precision)	postgres	less-than
	float8mi(double precision, double precision)	postgres	subtract
	float8mul(double precision, double precision)	postgres	multiply
	float8ne(double precision, double precision)	postgres	not equal
	float8out(double precision)	postgres	I/O
	float8pl(double precision, double precision)	postgres	add
	float8recv(internal)	postgres	I/O
	float8send(double precision)	postgres	I/O
	float8smaller(double precision, double precision)	postgres	smaller of two
	float8um(double precision)	postgres	negate
	float8up(double precision)	postgres	unary plus
	floor(numeric)	postgres	largest integer <= value
	floor(double precision)	postgres	largest integer <= value
	flt4_mul_cash(real, money)	postgres	multiply
	flt8_mul_cash(double precision, money)	postgres	multiply
	fmgr_c_validator(oid)	postgres	(internal)
	fmgr_internal_validator(oid)	postgres	(internal)
	fmgr_sql_validator(oid)	postgres	(internal)
	format_type(oid, integer)	postgres	format a type oid and atttypmod to canonical SQL
	gb18030_to_utf8(integer, integer, cstring, internal, integer)	postgres
	gbk_to_utf8(integer, integer, cstring, internal, integer)	postgres
	generate_series(bigint, bigint)	postgres	non-persistent series generator
	generate_series(integer, integer, integer)	postgres	non-persistent series generator
	generate_series(bigint, bigint, bigint)	postgres	non-persistent series generator
	generate_series(integer, integer)	postgres	non-persistent series generator
	get_bit(bytea, integer)	postgres	get bit
	get_byte(bytea, integer)	postgres	get byte
	getdatabaseencoding()	postgres	encoding name of current database
	getpgusername()	postgres	deprecated -- use current_user
	ginarrayconsistent(internal, smallint, internal)	postgres	GIN array support
	ginarrayextract(anyarray, internal)	postgres	GIN array support
	ginbeginscan(internal, internal, internal)	postgres	gin(internal)
	ginbuild(internal, internal, internal)	postgres	gin(internal)
	ginbulkdelete(internal, internal, internal, internal)	postgres	gin(internal)
	gincostestimate(internal, internal, internal, internal, internal, internal, internal, internal)	postgres	gin(internal)
	ginendscan(internal)	postgres	gin(internal)
	gingetmulti(internal, internal, internal, internal)	postgres	gin(internal)
	gingettuple(internal, internal)	postgres	gin(internal)
	gininsert(internal, internal, internal, internal, internal, internal)	postgres	gin(internal)
	ginmarkpos(internal)	postgres	gin(internal)
	ginoptions(boolean)	postgres	gin(internal)
	ginrescan(internal, internal)	postgres	gin(internal)
	ginrestrpos(internal)	postgres	gin(internal)
	ginvacuumcleanup(internal, internal)	postgres	gin(internal)
	gist_box_compress(internal)	postgres	GiST support
	gist_box_consistent(internal, box, integer)	postgres	GiST support
	gist_box_decompress(internal)	postgres	GiST support
	gist_box_penalty(internal, internal, internal)	postgres	GiST support
	gist_box_picksplit(internal, internal)	postgres	GiST support
	gist_box_same(box, box, internal)	postgres	GiST support
	gist_box_union(internal, internal)	postgres	GiST support
	gist_circle_compress(internal)	postgres	GiST support
	gist_circle_consistent(internal, circle, integer)	postgres	GiST support
	gist_poly_compress(internal)	postgres	GiST support
	gist_poly_consistent(internal, polygon, integer)	postgres	GiST support
	gistbeginscan(internal, internal, internal)	postgres	gist(internal)
	gistbuild(internal, internal, internal)	postgres	gist(internal)
	gistbulkdelete(internal, internal, internal, internal)	postgres	gist(internal)
	gistcostestimate(internal, internal, internal, internal, internal, internal, internal, internal)	postgres	gist(internal)
	gistendscan(internal)	postgres	gist(internal)
	gistgetmulti(internal, internal, internal, internal)	postgres	gist(internal)
	gistgettuple(internal, internal)	postgres	gist(internal)
	gistinsert(internal, internal, internal, internal, internal, internal)	postgres	gist(internal)
	gistmarkpos(internal)	postgres	gist(internal)
	gistoptions(boolean)	postgres	gist(internal)
	gistrescan(internal, internal)	postgres	gist(internal)
	gistrestrpos(internal)	postgres	gist(internal)
	gistvacuumcleanup(internal, internal)	postgres	gist(internal)
	has_database_privilege(oid, text, text)	postgres	user privilege on database by user oid, database name
	has_database_privilege(oid, text)	postgres	current user privilege on database by database oid
	has_database_privilege(name, oid, text)	postgres	user privilege on database by username, database oid
	has_database_privilege(oid, oid, text)	postgres	user privilege on database by user oid, database oid
	has_database_privilege(name, text, text)	postgres	user privilege on database by username, database name
	has_database_privilege(text, text)	postgres	current user privilege on database by database name
	has_function_privilege(oid, oid, text)	postgres	user privilege on function by user oid, function oid
	has_function_privilege(name, oid, text)	postgres	user privilege on function by username, function oid
	has_function_privilege(text, text)	postgres	current user privilege on function by function name
	has_function_privilege(oid, text)	postgres	current user privilege on function by function oid
	has_function_privilege(name, text, text)	postgres	user privilege on function by username, function name
	has_function_privilege(oid, text, text)	postgres	user privilege on function by user oid, function name
	has_language_privilege(oid, text, text)	postgres	user privilege on language by user oid, language name
	has_language_privilege(name, text, text)	postgres	user privilege on language by username, language name
	has_language_privilege(name, oid, text)	postgres	user privilege on language by username, language oid
	has_language_privilege(text, text)	postgres	current user privilege on language by language name
	has_language_privilege(oid, text)	postgres	current user privilege on language by language oid
	has_language_privilege(oid, oid, text)	postgres	user privilege on language by user oid, language oid
	has_schema_privilege(name, oid, text)	postgres	user privilege on schema by username, schema oid
	has_schema_privilege(oid, text, text)	postgres	user privilege on schema by user oid, schema name
	has_schema_privilege(name, text, text)	postgres	user privilege on schema by username, schema name
	has_schema_privilege(text, text)	postgres	current user privilege on schema by schema name
	has_schema_privilege(oid, text)	postgres	current user privilege on schema by schema oid
	has_schema_privilege(oid, oid, text)	postgres	user privilege on schema by user oid, schema oid
	has_table_privilege(oid, text)	postgres	current user privilege on relation by rel oid
	has_table_privilege(name, text, text)	postgres	user privilege on relation by username, rel name
	has_table_privilege(name, oid, text)	postgres	user privilege on relation by username, rel oid
	has_table_privilege(oid, text, text)	postgres	user privilege on relation by user oid, rel name
	has_table_privilege(oid, oid, text)	postgres	user privilege on relation by user oid, rel oid
	has_table_privilege(text, text)	postgres	current user privilege on relation by rel name
	has_tablespace_privilege(text, text)	postgres	current user privilege on tablespace by tablespace name
	has_tablespace_privilege(oid, text, text)	postgres	user privilege on tablespace by user oid, tablespace name
	has_tablespace_privilege(oid, oid, text)	postgres	user privilege on tablespace by user oid, tablespace oid
	has_tablespace_privilege(oid, text)	postgres	current user privilege on tablespace by tablespace oid
	has_tablespace_privilege(name, text, text)	postgres	user privilege on tablespace by username, tablespace name
	has_tablespace_privilege(name, oid, text)	postgres	user privilege on tablespace by username, tablespace oid
	hash_aclitem(aclitem)	postgres	hash
	hashbeginscan(internal, internal, internal)	postgres	hash(internal)
	hashbpchar(character)	postgres	hash
	hashbuild(internal, internal, internal)	postgres	hash(internal)
	hashbulkdelete(internal, internal, internal, internal)	postgres	hash(internal)
	hashchar("char")	postgres	hash
	hashcostestimate(internal, internal, internal, internal, internal, internal, internal, internal)	postgres	hash(internal)
	hashendscan(internal)	postgres	hash(internal)
	hashfloat4(real)	postgres	hash
	hashfloat8(double precision)	postgres	hash
	hashgetmulti(internal, internal, internal, internal)	postgres	hash(internal)
	hashgettuple(internal, internal)	postgres	hash(internal)
	hashinet(inet)	postgres	hash
	hashinsert(internal, internal, internal, internal, internal, internal)	postgres	hash(internal)
	hashint2(smallint)	postgres	hash
	hashint2vector(int2vector)	postgres	hash
	hashint4(integer)	postgres	hash
	hashint8(bigint)	postgres	hash
	hashmacaddr(macaddr)	postgres	hash
	hashmarkpos(internal)	postgres	hash(internal)
	hashname(name)	postgres	hash
	hashoid(oid)	postgres	hash
	hashoidvector(oidvector)	postgres	hash
	hashoptions(boolean)	postgres	hash(internal)
	hashrescan(internal, internal)	postgres	hash(internal)
	hashrestrpos(internal)	postgres	hash(internal)
	hashtext(text)	postgres	hash
	hashvacuumcleanup(internal, internal)	postgres	hash(internal)
	hashvarlena(internal)	postgres	hash any varlena type
	height(box)	postgres	box height
	host(inet)	postgres	show address octets only
	hostmask(inet)	postgres	hostmask of address
	iclikejoinsel(internal, oid, internal, smallint)	postgres	join selectivity of ILIKE
	iclikesel(internal, oid, internal, integer)	postgres	restriction selectivity of ILIKE
	icnlikejoinsel(internal, oid, internal, smallint)	postgres	join selectivity of NOT ILIKE
	icnlikesel(internal, oid, internal, integer)	postgres	restriction selectivity of NOT ILIKE
	icregexeqjoinsel(internal, oid, internal, smallint)	postgres	join selectivity of case-insensitive regex match
	icregexeqsel(internal, oid, internal, integer)	postgres	restriction selectivity of case-insensitive regex match
	icregexnejoinsel(internal, oid, internal, smallint)	postgres	join selectivity of case-insensitive regex non-match
	icregexnesel(internal, oid, internal, integer)	postgres	restriction selectivity of case-insensitive regex non-match
	inet(text)	postgres	text to inet
	inet_client_addr()	postgres	inet address of the client
	inet_client_port()	postgres	client's port number for this connection
	inet_in(cstring)	postgres	I/O
	inet_out(inet)	postgres	I/O
	inet_recv(internal)	postgres	I/O
	inet_send(inet)	postgres	I/O
	inet_server_addr()	postgres	inet address of the server
	inet_server_port()	postgres	server's port number for this connection
	inetand(inet, inet)	postgres	bitwise and
	inetmi(inet, inet)	postgres	subtract inet values
	inetmi_int8(inet, bigint)	postgres	subtract integer from inet value
	inetnot(inet)	postgres	bitwise not
	inetor(inet, inet)	postgres	bitwise or
	inetpl(inet, bigint)	postgres	add integer to inet value
	initcap(text)	postgres	capitalize each word
	int2(integer)	postgres	convert int4 to int2
	int2(numeric)	postgres	(internal)
	int2(bigint)	postgres	convert int8 to int2
	int2(text)	postgres	convert text to int2
	int2(double precision)	postgres	convert float8 to int2
	int2(real)	postgres	convert float4 to int2
	int24div(smallint, integer)	postgres	divide
	int24eq(smallint, integer)	postgres	equal
	int24ge(smallint, integer)	postgres	greater-than-or-equal
	int24gt(smallint, integer)	postgres	greater-than
	int24le(smallint, integer)	postgres	less-than-or-equal
	int24lt(smallint, integer)	postgres	less-than
	int24mi(smallint, integer)	postgres	subtract
	int24mod(smallint, integer)	postgres	modulus
	int24mul(smallint, integer)	postgres	multiply
	int24ne(smallint, integer)	postgres	not equal
	int24pl(smallint, integer)	postgres	add
	int28eq(smallint, bigint)	postgres	equal
	int28ge(smallint, bigint)	postgres	greater-than-or-equal
	int28gt(smallint, bigint)	postgres	greater-than
	int28le(smallint, bigint)	postgres	less-than-or-equal
	int28lt(smallint, bigint)	postgres	less-than
	int28ne(smallint, bigint)	postgres	not equal
	int2_accum(smallint)	postgres	aggregate transition function
	int2_avg_accum(smallint)	postgres	AVG(int2) transition function
	int2_mul_cash(smallint, money)	postgres	multiply
	int2_sum(bigint, smallint)	postgres	SUM(int2) transition function
	int2abs(smallint)	postgres	absolute value
	int2and(smallint, smallint)	postgres	bitwise and
	int2div(smallint, smallint)	postgres	divide
	int2eq(smallint, smallint)	postgres	equal
	int2ge(smallint, smallint)	postgres	greater-than-or-equal
	int2gt(smallint, smallint)	postgres	greater-than
	int2in(cstring)	postgres	I/O
	int2larger(smallint, smallint)	postgres	larger of two
	int2le(smallint, smallint)	postgres	less-than-or-equal
	int2lt(smallint, smallint)	postgres	less-than
	int2mi(smallint, smallint)	postgres	subtract
	int2mod(smallint, smallint)	postgres	modulus
	int2mul(smallint, smallint)	postgres	multiply
	int2ne(smallint, smallint)	postgres	not equal
	int2not(smallint)	postgres	bitwise not
	int2or(smallint, smallint)	postgres	bitwise or
	int2out(smallint)	postgres	I/O
	int2pl(smallint, smallint)	postgres	add
	int2recv(internal)	postgres	I/O
	int2send(smallint)	postgres	I/O
	int2shl(smallint, integer)	postgres	bitwise shift left
	int2shr(smallint, integer)	postgres	bitwise shift right
	int2smaller(smallint, smallint)	postgres	smaller of two
	int2um(smallint)	postgres	negate
	int2up(smallint)	postgres	unary plus
	int2vectoreq(int2vector, int2vector)	postgres	equal
	int2vectorin(cstring)	postgres	I/O
	int2vectorout(int2vector)	postgres	I/O
	int2vectorrecv(internal)	postgres	I/O
	int2vectorsend(int2vector)	postgres	I/O
	int2xor(smallint, smallint)	postgres	bitwise xor
	int4(text)	postgres	convert text to int4
	int4(double precision)	postgres	convert float8 to int4
	int4(bit)	postgres	bitstring to int4
	int4(real)	postgres	convert float4 to int4
	int4(bigint)	postgres	convert int8 to int4
	int4(smallint)	postgres	convert int2 to int4
	int4(numeric)	postgres	(internal)
	int4("char")	postgres	convert char to int4
	int4(boolean)	postgres	convert boolean to int4
	int42div(integer, smallint)	postgres	divide
	int42eq(integer, smallint)	postgres	equal
	int42ge(integer, smallint)	postgres	greater-than-or-equal
	int42gt(integer, smallint)	postgres	greater-than
	int42le(integer, smallint)	postgres	less-than-or-equal
	int42lt(integer, smallint)	postgres	less-than
	int42mi(integer, smallint)	postgres	subtract
	int42mod(integer, smallint)	postgres	modulus
	int42mul(integer, smallint)	postgres	multiply
	int42ne(integer, smallint)	postgres	not equal
	int42pl(integer, smallint)	postgres	add
	int48div(integer, bigint)	postgres	divide
	int48eq(integer, bigint)	postgres	equal
	int48ge(integer, bigint)	postgres	greater-than-or-equal
	int48gt(integer, bigint)	postgres	greater-than
	int48le(integer, bigint)	postgres	less-than-or-equal
	int48lt(integer, bigint)	postgres	less-than
	int48mi(integer, bigint)	postgres	subtract
	int48mul(integer, bigint)	postgres	multiply
	int48ne(integer, bigint)	postgres	not equal
	int48pl(integer, bigint)	postgres	add
	int4_accum(integer)	postgres	aggregate transition function
	int4_avg_accum(integer)	postgres	AVG(int4) transition function
	int4_mul_cash(integer, money)	postgres	multiply
	int4_sum(bigint, integer)	postgres	SUM(int4) transition function
	int4abs(integer)	postgres	absolute value
	int4and(integer, integer)	postgres	bitwise and
	int4div(integer, integer)	postgres	divide
	int4eq(integer, integer)	postgres	equal
	int4ge(integer, integer)	postgres	greater-than-or-equal
	int4gt(integer, integer)	postgres	greater-than
	int4in(cstring)	postgres	I/O
	int4inc(integer)	postgres	increment
	int4larger(integer, integer)	postgres	larger of two
	int4le(integer, integer)	postgres	less-than-or-equal
	int4lt(integer, integer)	postgres	less-than
	int4mi(integer, integer)	postgres	subtract
	int4mod(integer, integer)	postgres	modulus
	int4mul(integer, integer)	postgres	multiply
	int4ne(integer, integer)	postgres	not equal
	int4not(integer)	postgres	bitwise not
	int4notin(integer, text)	postgres	not in
	int4or(integer, integer)	postgres	bitwise or
	int4out(integer)	postgres	I/O
	int4pl(integer, integer)	postgres	add
	int4recv(internal)	postgres	I/O
	int4send(integer)	postgres	I/O
	int4shl(integer, integer)	postgres	bitwise shift left
	int4shr(integer, integer)	postgres	bitwise shift right
	int4smaller(integer, integer)	postgres	smaller of two
	int4um(integer)	postgres	negate
	int4up(integer)	postgres	unary plus
	int4xor(integer, integer)	postgres	bitwise xor
	int8(bit)	postgres	bitstring to int8
	int8(oid)	postgres	convert oid to int8
	int8(text)	postgres	convert text to int8
	int8(numeric)	postgres	(internal)
	int8(smallint)	postgres	convert int2 to int8
	int8(integer)	postgres	convert int4 to int8
	int8(real)	postgres	convert float4 to int8
	int8(double precision)	postgres	convert float8 to int8
	int82eq(bigint, smallint)	postgres	equal
	int82ge(bigint, smallint)	postgres	greater-than-or-equal
	int82gt(bigint, smallint)	postgres	greater-than
	int82le(bigint, smallint)	postgres	less-than-or-equal
	int82lt(bigint, smallint)	postgres	less-than
	int82ne(bigint, smallint)	postgres	not equal
	int84div(bigint, integer)	postgres	divide
	int84eq(bigint, integer)	postgres	equal
	int84ge(bigint, integer)	postgres	greater-than-or-equal
	int84gt(bigint, integer)	postgres	greater-than
	int84le(bigint, integer)	postgres	less-than-or-equal
	int84lt(bigint, integer)	postgres	less-than
	int84mi(bigint, integer)	postgres	subtract
	int84mul(bigint, integer)	postgres	multiply
	int84ne(bigint, integer)	postgres	not equal
	int84pl(bigint, integer)	postgres	add
	int8_accum(bigint)	postgres	aggregate transition function
	int8_avg()	postgres	AVG(int) aggregate final function
	int8_sum(numeric, bigint)	postgres	SUM(int8) transition function
	int8abs(bigint)	postgres	absolute value
	int8and(bigint, bigint)	postgres	bitwise and
	int8div(bigint, bigint)	postgres	divide
	int8eq(bigint, bigint)	postgres	equal
	int8ge(bigint, bigint)	postgres	greater-than-or-equal
	int8gt(bigint, bigint)	postgres	greater-than
	int8in(cstring)	postgres	I/O
	int8inc(bigint)	postgres	increment
	int8inc_any(bigint, "any")	postgres	increment, ignores second argument
	int8inc_float8_float8(bigint, double precision, double precision)	postgres	REGR_COUNT(double, double) transition function
	int8larger(bigint, bigint)	postgres	larger of two
	int8le(bigint, bigint)	postgres	less-than-or-equal
	int8lt(bigint, bigint)	postgres	less-than
	int8mi(bigint, bigint)	postgres	subtract
	int8mod(bigint, bigint)	postgres	modulus
	int8mul(bigint, bigint)	postgres	multiply
	int8ne(bigint, bigint)	postgres	not equal
	int8not(bigint)	postgres	bitwise not
	int8or(bigint, bigint)	postgres	bitwise or
	int8out(bigint)	postgres	I/O
	int8pl(bigint, bigint)	postgres	add
	int8pl_inet(bigint, inet)	postgres	add integer to inet value
	int8recv(internal)	postgres	I/O
	int8send(bigint)	postgres	I/O
	int8shl(bigint, integer)	postgres	bitwise shift left
	int8shr(bigint, integer)	postgres	bitwise shift right
	int8smaller(bigint, bigint)	postgres	smaller of two
	int8um(bigint)	postgres	negate
	int8up(bigint)	postgres	unary plus
	int8xor(bigint, bigint)	postgres	bitwise xor
	integer_pl_date(integer, date)	postgres
	inter_lb(line, box)	postgres	intersect?
	inter_sb(lseg, box)	postgres	intersect?
	inter_sl(lseg, line)	postgres	intersect?
	internal_in(cstring)	postgres	I/O
	internal_out(internal)	postgres	I/O
	interval(time without time zone)	postgres	convert time to interval
	interval(interval, integer)	postgres	adjust interval precision
	interval(reltime)	postgres	convert reltime to interval
	interval(text)	postgres	convert text to interval
	interval_accum(interval)	postgres	aggregate transition function
	interval_avg()	postgres	AVG aggregate final function
	interval_cmp(interval, interval)	postgres	less-equal-greater
	interval_div(interval, double precision)	postgres	divide
	interval_eq(interval, interval)	postgres	equal
	interval_ge(interval, interval)	postgres	greater-than-or-equal
	interval_gt(interval, interval)	postgres	greater-than
	interval_hash(interval)	postgres	hash
	interval_in(cstring, oid, integer)	postgres	I/O
	interval_larger(interval, interval)	postgres	larger of two
	interval_le(interval, interval)	postgres	less-than-or-equal
	interval_lt(interval, interval)	postgres	less-than
	interval_mi(interval, interval)	postgres	subtract
	interval_mul(interval, double precision)	postgres	multiply interval
	interval_ne(interval, interval)	postgres	not equal
	interval_out(interval)	postgres	I/O
	interval_pl(interval, interval)	postgres	add
	interval_pl_date(interval, date)	postgres
	interval_pl_time(interval, time without time zone)	postgres	plus
	interval_pl_timestamp(interval, timestamp without time zone)	postgres
	interval_pl_timestamptz(interval, timestamp with time zone)	postgres
	interval_pl_timetz(interval, time with time zone)	postgres
	interval_recv(internal, oid, integer)	postgres	I/O
	interval_send(interval)	postgres	I/O
	interval_smaller(interval, interval)	postgres	smaller of two
	interval_um(interval)	postgres	subtract
	intinterval(abstime, tinterval)	postgres	abstime in tinterval
	isclosed(path)	postgres	path closed?
	isfalse(boolean)	postgres	bool is false (not true or unknown)
	isfinite(timestamp with time zone)	postgres	finite timestamp?
	isfinite(abstime)	postgres	finite abstime?
	isfinite(interval)	postgres	finite interval?
	isfinite(timestamp without time zone)	postgres	finite timestamp?
	ishorizontal(line)	postgres	horizontal?
	ishorizontal(point, point)	postgres	horizontally aligned?
	ishorizontal(lseg)	postgres	horizontal?
	isnotfalse(boolean)	postgres	bool is not false (ie, true or unknown)
	isnottrue(boolean)	postgres	bool is not true (ie, false or unknown)
	iso8859_1_to_utf8(integer, integer, cstring, internal, integer)	postgres
	iso8859_to_utf8(integer, integer, cstring, internal, integer)	postgres
	iso_to_koi8r(integer, integer, cstring, internal, integer)	postgres
	iso_to_mic(integer, integer, cstring, internal, integer)	postgres
	iso_to_win1251(integer, integer, cstring, internal, integer)	postgres
	iso_to_win866(integer, integer, cstring, internal, integer)	postgres
	isopen(path)	postgres	path open?
	isparallel(lseg, lseg)	postgres	parallel?
	isparallel(line, line)	postgres	parallel?
	isperp(lseg, lseg)	postgres	perpendicular?
	isperp(line, line)	postgres	perpendicular?
	istrue(boolean)	postgres	bool is true (not false or unknown)
	isvertical(line)	postgres	vertical?
	isvertical(point, point)	postgres	vertically aligned?
	isvertical(lseg)	postgres	vertical?
	johab_to_utf8(integer, integer, cstring, internal, integer)	postgres
	justify_days(interval)	postgres	promote groups of 30 days to numbers of months
	justify_hours(interval)	postgres	promote groups of 24 hours to numbers of days
	justify_interval(interval)	postgres	promote groups of 24 hours to numbers of days and promote groups of 30 days to numbers of months
	koi8r_to_iso(integer, integer, cstring, internal, integer)	postgres
	koi8r_to_mic(integer, integer, cstring, internal, integer)	postgres
	koi8r_to_utf8(integer, integer, cstring, internal, integer)	postgres
	koi8r_to_win1251(integer, integer, cstring, internal, integer)	postgres
	koi8r_to_win866(integer, integer, cstring, internal, integer)	postgres
	language_handler_in(cstring)	postgres	I/O
	language_handler_out(language_handler)	postgres	I/O
	lastval()	postgres	current value from last used sequence
	latin1_to_mic(integer, integer, cstring, internal, integer)	postgres
	latin2_to_mic(integer, integer, cstring, internal, integer)	postgres
	latin2_to_win1250(integer, integer, cstring, internal, integer)	postgres
	latin3_to_mic(integer, integer, cstring, internal, integer)	postgres
	latin4_to_mic(integer, integer, cstring, internal, integer)	postgres
	length(path)	postgres	sum of path segments
	length(character)	postgres	character length
	length(text)	postgres	length
	length(bytea)	postgres	octet length
	length(bit)	postgres	bitstring length
	length(lseg)	postgres	distance between endpoints
	like(bytea, bytea)	postgres	matches LIKE expression
	like(name, text)	postgres	matches LIKE expression
	like(text, text)	postgres	matches LIKE expression
	like_escape(text, text)	postgres	convert LIKE pattern to use backslash escapes
	like_escape(bytea, bytea)	postgres	convert LIKE pattern to use backslash escapes
	likejoinsel(internal, oid, internal, smallint)	postgres	join selectivity of LIKE
	likesel(internal, oid, internal, integer)	postgres	restriction selectivity of LIKE
	line(point, point)	postgres	line from points
	line_distance(line, line)	postgres	distance between
	line_eq(line, line)	postgres	lines equal?
	line_horizontal(line)	postgres	horizontal?
	line_in(cstring)	postgres	I/O
	line_interpt(line, line)	postgres	intersection point
	line_intersect(line, line)	postgres	intersect?
	line_out(line)	postgres	I/O
	line_parallel(line, line)	postgres	parallel?
	line_perp(line, line)	postgres	perpendicular?
	line_recv(internal)	postgres	I/O
	line_send(line)	postgres	I/O
	line_vertical(line)	postgres	vertical?
	ln(double precision)	postgres	natural logarithm
	ln(numeric)	postgres	natural logarithm of n
	lo_close(integer)	postgres	large object close
	lo_creat(integer)	postgres	large object create
	lo_create(oid)	postgres	large object create
	lo_export(oid, text)	postgres	large object export
	lo_import(text)	postgres	large object import
	lo_lseek(integer, integer, integer)	postgres	large object seek
	lo_open(oid, integer)	postgres	large object open
	lo_tell(integer)	postgres	large object position
	lo_unlink(oid)	postgres	large object unlink(delete)
	log(numeric)	postgres	logarithm base 10 of n
	log(numeric, numeric)	postgres	logarithm base m of n
	log(double precision)	postgres	base 10 logarithm
	loread(integer, integer)	postgres	large object read
	lower(text)	postgres	lowercase
	lowrite(integer, bytea)	postgres	large object write
	lpad(text, integer)	postgres	left-pad string to length
	lpad(text, integer, text)	postgres	left-pad string to length
	lseg(point, point)	postgres	convert points to line segment
	lseg(box)	postgres	diagonal of
	lseg_center(lseg)	postgres	center of
	lseg_distance(lseg, lseg)	postgres	distance between
	lseg_eq(lseg, lseg)	postgres	equal
	lseg_ge(lseg, lseg)	postgres	greater-than-or-equal by length
	lseg_gt(lseg, lseg)	postgres	greater-than by length
	lseg_horizontal(lseg)	postgres	horizontal?
	lseg_in(cstring)	postgres	I/O
	lseg_interpt(lseg, lseg)	postgres	intersection point
	lseg_intersect(lseg, lseg)	postgres	intersect?
	lseg_le(lseg, lseg)	postgres	less-than-or-equal by length
	lseg_length(lseg)	postgres	distance between endpoints
	lseg_lt(lseg, lseg)	postgres	less-than by length
	lseg_ne(lseg, lseg)	postgres	not equal
	lseg_out(lseg)	postgres	I/O
	lseg_parallel(lseg, lseg)	postgres	parallel?
	lseg_perp(lseg, lseg)	postgres	perpendicular?
	lseg_recv(internal)	postgres	I/O
	lseg_send(lseg)	postgres	I/O
	lseg_vertical(lseg)	postgres	vertical?
	ltrim(text)	postgres	trim spaces from left end of string
	ltrim(text, text)	postgres	trim selected characters from left end of string
	macaddr(text)	postgres	text to MAC address
	macaddr_cmp(macaddr, macaddr)	postgres	less-equal-greater
	macaddr_eq(macaddr, macaddr)	postgres	equal
	macaddr_ge(macaddr, macaddr)	postgres	greater-than-or-equal
	macaddr_gt(macaddr, macaddr)	postgres	greater-than
	macaddr_in(cstring)	postgres	I/O
	macaddr_le(macaddr, macaddr)	postgres	less-than-or-equal
	macaddr_lt(macaddr, macaddr)	postgres	less-than
	macaddr_ne(macaddr, macaddr)	postgres	not equal
	macaddr_out(macaddr)	postgres	I/O
	macaddr_recv(internal)	postgres	I/O
	macaddr_send(macaddr)	postgres	I/O
	makeaclitem(oid, oid, text, boolean)	postgres	make ACL item
	masklen(inet)	postgres	netmask length
	md5(bytea)	postgres	calculates md5 hash
	md5(text)	postgres	calculates md5 hash
	mic_to_ascii(integer, integer, cstring, internal, integer)	postgres
	mic_to_big5(integer, integer, cstring, internal, integer)	postgres
	mic_to_euc_cn(integer, integer, cstring, internal, integer)	postgres
	mic_to_euc_jp(integer, integer, cstring, internal, integer)	postgres
	mic_to_euc_kr(integer, integer, cstring, internal, integer)	postgres
	mic_to_euc_tw(integer, integer, cstring, internal, integer)	postgres
	mic_to_iso(integer, integer, cstring, internal, integer)	postgres
	mic_to_koi8r(integer, integer, cstring, internal, integer)	postgres
	mic_to_latin1(integer, integer, cstring, internal, integer)	postgres
	mic_to_latin2(integer, integer, cstring, internal, integer)	postgres
	mic_to_latin3(integer, integer, cstring, internal, integer)	postgres
	mic_to_latin4(integer, integer, cstring, internal, integer)	postgres
	mic_to_sjis(integer, integer, cstring, internal, integer)	postgres
	mic_to_win1250(integer, integer, cstring, internal, integer)	postgres
	mic_to_win1251(integer, integer, cstring, internal, integer)	postgres
	mic_to_win866(integer, integer, cstring, internal, integer)	postgres
	mktinterval(abstime, abstime)	postgres	convert to tinterval
	mod(integer, integer)	postgres	modulus
	mod(smallint, smallint)	postgres	modulus
	mod(smallint, integer)	postgres	modulus
	mod(numeric, numeric)	postgres	modulus
	mod(integer, smallint)	postgres	modulus
	mod(bigint, bigint)	postgres	modulus
	mul_d_interval(double precision, interval)	postgres
	name(character varying)	postgres	convert varchar to name
	name(character)	postgres	convert char(n) to name
	name(text)	postgres	convert text to name
	name_pattern_eq(name, name)	postgres
	name_pattern_ge(name, name)	postgres
	name_pattern_gt(name, name)	postgres
	name_pattern_le(name, name)	postgres
	name_pattern_lt(name, name)	postgres
	name_pattern_ne(name, name)	postgres
	nameeq(name, name)	postgres	equal
	namege(name, name)	postgres	greater-than-or-equal
	namegt(name, name)	postgres	greater-than
	nameiclike(name, text)	postgres	matches LIKE expression, case-insensitive
	nameicnlike(name, text)	postgres	does not match LIKE expression, case-insensitive
	nameicregexeq(name, text)	postgres	matches regex., case-insensitive
	nameicregexne(name, text)	postgres	does not match regex., case-insensitive
	namein(cstring)	postgres	I/O
	namele(name, name)	postgres	less-than-or-equal
	namelike(name, text)	postgres	matches LIKE expression
	namelt(name, name)	postgres	less-than
	namene(name, name)	postgres	not equal
	namenlike(name, text)	postgres	does not match LIKE expression
	nameout(name)	postgres	I/O
	namerecv(internal)	postgres	I/O
	nameregexeq(name, text)	postgres	matches regex., case-sensitive
	nameregexne(name, text)	postgres	does not match regex., case-sensitive
	namesend(name)	postgres	I/O
	neqjoinsel(internal, oid, internal, smallint)	postgres	join selectivity of <> and related operators
	neqsel(internal, oid, internal, integer)	postgres	restriction selectivity of <> and related operators
	netmask(inet)	postgres	netmask of address
	network(inet)	postgres	network part of address
	network_cmp(inet, inet)	postgres	less-equal-greater
	network_eq(inet, inet)	postgres	equal
	network_ge(inet, inet)	postgres	greater-than-or-equal
	network_gt(inet, inet)	postgres	greater-than
	network_le(inet, inet)	postgres	less-than-or-equal
	network_lt(inet, inet)	postgres	less-than
	network_ne(inet, inet)	postgres	not equal
	network_sub(inet, inet)	postgres	is-subnet
	network_subeq(inet, inet)	postgres	is-subnet-or-equal
	network_sup(inet, inet)	postgres	is-supernet
	network_supeq(inet, inet)	postgres	is-supernet-or-equal
	nextval(regclass)	postgres	sequence next value
	nlikejoinsel(internal, oid, internal, smallint)	postgres	join selectivity of NOT LIKE
	nlikesel(internal, oid, internal, integer)	postgres	restriction selectivity of NOT LIKE
	nonnullvalue("any")	postgres	(internal)
	notlike(name, text)	postgres	does not match LIKE expression
	notlike(text, text)	postgres	does not match LIKE expression
	notlike(bytea, bytea)	postgres	does not match LIKE expression
	now()	postgres	current transaction time
	npoints(polygon)	postgres	number of points in polygon
	npoints(path)	postgres	number of points in path
	nullvalue("any")	postgres	(internal)
	numeric(smallint)	postgres	(internal)
	numeric(text)	postgres	(internal)
	numeric(numeric, integer)	postgres	adjust numeric to typmod precision/scale
	numeric(integer)	postgres	(internal)
	numeric(real)	postgres	(internal)
	numeric(double precision)	postgres	(internal)
	numeric(bigint)	postgres	(internal)
	numeric_abs(numeric)	postgres	absolute value
	numeric_accum(numeric)	postgres	aggregate transition function
	numeric_add(numeric, numeric)	postgres	add
	numeric_avg()	postgres	AVG aggregate final function
	numeric_cmp(numeric, numeric)	postgres	compare two numbers
	numeric_div(numeric, numeric)	postgres	divide
	numeric_eq(numeric, numeric)	postgres	equal
	numeric_exp(numeric)	postgres	e raised to the power of n
	numeric_fac(bigint)	postgres
	numeric_ge(numeric, numeric)	postgres	greater-than-or-equal
	numeric_gt(numeric, numeric)	postgres	greater-than
	numeric_in(cstring, oid, integer)	postgres	I/O
	numeric_inc(numeric)	postgres	increment by one
	numeric_larger(numeric, numeric)	postgres	larger of two numbers
	numeric_le(numeric, numeric)	postgres	less-than-or-equal
	numeric_ln(numeric)	postgres	natural logarithm of n
	numeric_log(numeric, numeric)	postgres	logarithm base m of n
	numeric_lt(numeric, numeric)	postgres	less-than
	numeric_mod(numeric, numeric)	postgres	modulus
	numeric_mul(numeric, numeric)	postgres	multiply
	numeric_ne(numeric, numeric)	postgres	not equal
	numeric_out(numeric)	postgres	I/O
	numeric_power(numeric, numeric)	postgres	m raised to the power of n
	numeric_recv(internal, oid, integer)	postgres	I/O
	numeric_send(numeric)	postgres	I/O
	numeric_smaller(numeric, numeric)	postgres	smaller of two numbers
	numeric_sqrt(numeric)	postgres	square root
	numeric_stddev_pop()	postgres	STDDEV_POP aggregate final function
	numeric_stddev_samp()	postgres	STDDEV_SAMP aggregate final function
	numeric_sub(numeric, numeric)	postgres	subtract
	numeric_uminus(numeric)	postgres	negate
	numeric_uplus(numeric)	postgres	unary plus
	numeric_var_pop()	postgres	VAR_POP aggregate final function
	numeric_var_samp()	postgres	VAR_SAMP aggregate final function
	obj_description(oid)	postgres	get description for object id (deprecated)
	obj_description(oid, name)	postgres	get description for object id and catalog name
	octet_length(bytea)	postgres	octet length
	octet_length(character)	postgres	octet length
	octet_length(text)	postgres	octet length
	octet_length(bit)	postgres	octet length
	oid(bigint)	postgres	convert int8 to oid
	oid(text)	postgres	convert text to oid
	oideq(oid, oid)	postgres	equal
	oidge(oid, oid)	postgres	greater-than-or-equal
	oidgt(oid, oid)	postgres	greater-than
	oidin(cstring)	postgres	I/O
	oidlarger(oid, oid)	postgres	larger of two
	oidle(oid, oid)	postgres	less-than-or-equal
	oidlt(oid, oid)	postgres	less-than
	oidne(oid, oid)	postgres	not equal
	oidnotin(oid, text)	postgres	not in
	oidout(oid)	postgres	I/O
	oidrecv(internal)	postgres	I/O
	oidsend(oid)	postgres	I/O
	oidsmaller(oid, oid)	postgres	smaller of two
	oidvectoreq(oidvector, oidvector)	postgres	equal
	oidvectorge(oidvector, oidvector)	postgres	greater-than-or-equal
	oidvectorgt(oidvector, oidvector)	postgres	greater-than
	oidvectorin(cstring)	postgres	I/O
	oidvectorle(oidvector, oidvector)	postgres	less-than-or-equal
	oidvectorlt(oidvector, oidvector)	postgres	less-than
	oidvectorne(oidvector, oidvector)	postgres	not equal
	oidvectorout(oidvector)	postgres	I/O
	oidvectorrecv(internal)	postgres	I/O
	oidvectorsend(oidvector)	postgres	I/O
	oidvectortypes(oidvector)	postgres	print type names of oidvector field
	on_pb(point, box)	postgres	point inside box?
	on_pl(point, line)	postgres	point on line?
	on_ppath(point, path)	postgres	point within closed path, or point on open path
	on_ps(point, lseg)	postgres	point contained in segment?
	on_sb(lseg, box)	postgres	lseg contained in box?
	on_sl(lseg, line)	postgres	lseg on line?
	opaque_in(cstring)	postgres	I/O
	opaque_out(opaque)	postgres	I/O
	overlaps(timestamp with time zone, timestamp with time zone, timestamp with time zone, timestamp with time zone)	postgres	SQL92 interval comparison
	overlaps(time without time zone, time without time zone, time without time zone, time without time zone)	postgres	SQL92 interval comparison
	overlaps(time without time zone, interval, time without time zone, interval)	postgres	SQL92 interval comparison
	overlaps(time without time zone, time without time zone, time without time zone, interval)	postgres	SQL92 interval comparison
	overlaps(time without time zone, interval, time without time zone, time without time zone)	postgres	SQL92 interval comparison
	overlaps(time with time zone, time with time zone, time with time zone, time with time zone)	postgres	SQL92 interval comparison
	overlaps(timestamp without time zone, interval, timestamp without time zone, timestamp without time zone)	postgres	SQL92 interval comparison
	overlaps(timestamp without time zone, timestamp without time zone, timestamp without time zone, interval)	postgres	SQL92 interval comparison
	overlaps(timestamp without time zone, interval, timestamp without time zone, interval)	postgres	SQL92 interval comparison
	overlaps(timestamp with time zone, interval, timestamp with time zone, interval)	postgres	SQL92 interval comparison
	overlaps(timestamp with time zone, timestamp with time zone, timestamp with time zone, interval)	postgres	SQL92 interval comparison
	overlaps(timestamp without time zone, timestamp without time zone, timestamp without time zone, timestamp without time zone)	postgres	SQL92 interval comparison
	overlaps(timestamp with time zone, interval, timestamp with time zone, timestamp with time zone)	postgres	SQL92 interval comparison
	overlay(text, text, integer)	postgres	substitute portion of string
	overlay(text, text, integer, integer)	postgres	substitute portion of string
	path(polygon)	postgres	convert polygon to path
	path_add(path, path)	postgres	concatenate open paths
	path_add_pt(path, point)	postgres	add (translate path)
	path_center(path)	postgres	center of
	path_contain_pt(path, point)	postgres	path contains point?
	path_distance(path, path)	postgres	distance between paths
	path_div_pt(path, point)	postgres	divide (rotate/scale path)
	path_in(cstring)	postgres	I/O
	path_inter(path, path)	postgres	intersect?
	path_length(path)	postgres	sum of path segment lengths
	path_mul_pt(path, point)	postgres	multiply (rotate/scale path)
	path_n_eq(path, path)	postgres	equal
	path_n_ge(path, path)	postgres	greater-than-or-equal
	path_n_gt(path, path)	postgres	greater-than
	path_n_le(path, path)	postgres	less-than-or-equal
	path_n_lt(path, path)	postgres	less-than
	path_npoints(path)	postgres	number of points in path
	path_out(path)	postgres	I/O
	path_recv(internal)	postgres	I/O
	path_send(path)	postgres	I/O
	path_sub_pt(path, point)	postgres	subtract (translate path)
	pclose(path)	postgres	close path
	pg_advisory_lock(bigint)	postgres	obtain exclusive advisory lock
	pg_advisory_lock(integer, integer)	postgres	obtain exclusive advisory lock
	pg_advisory_lock_shared(bigint)	postgres	obtain shared advisory lock
	pg_advisory_lock_shared(integer, integer)	postgres	obtain shared advisory lock
	pg_advisory_unlock(integer, integer)	postgres	release exclusive advisory lock
	pg_advisory_unlock(bigint)	postgres	release exclusive advisory lock
	pg_advisory_unlock_all()	postgres	release all advisory locks
	pg_advisory_unlock_shared(bigint)	postgres	release shared advisory lock
	pg_advisory_unlock_shared(integer, integer)	postgres	release shared advisory lock
	pg_backend_pid()	postgres	Statistics: Current backend PID
	pg_cancel_backend(integer)	postgres	Cancel a server process' current query
	pg_char_to_encoding(name)	postgres	convert encoding name to encoding id
	pg_client_encoding()	postgres	encoding name of current database
	pg_column_size("any")	postgres	bytes required to store the value, perhaps with compression
	pg_conversion_is_visible(oid)	postgres	is conversion visible in search path?
	pg_current_xlog_insert_location()	postgres	current xlog insert location
	pg_current_xlog_location()	postgres	current xlog write location
	pg_cursor()	postgres	get the open cursors for this session
	pg_database_size(name)	postgres	Calculate total disk space usage for the specified database
	pg_database_size(oid)	postgres	Calculate total disk space usage for the specified database
	pg_encoding_to_char(integer)	postgres	convert encoding id to encoding name
	pg_file_length(text)	postgres
	pg_file_read(text, bigint, bigint)	postgres
	pg_file_rename(text, text, text)	postgres
	pg_file_rename(text, text)	postgres
	pg_file_unlink(text)	postgres
	pg_file_write(text, text, boolean)	postgres
	pg_function_is_visible(oid)	postgres	is function visible in search path?
	pg_get_constraintdef(oid)	postgres	constraint description
	pg_get_constraintdef(oid, boolean)	postgres	constraint description with pretty-print option
	pg_get_expr(text, oid)	postgres	deparse an encoded expression
	pg_get_expr(text, oid, boolean)	postgres	deparse an encoded expression with pretty-print option
	pg_get_indexdef(oid)	postgres	index description
	pg_get_indexdef(oid, integer, boolean)	postgres	index description (full create statement or single expression) with pretty-print option
	pg_get_ruledef(oid)	postgres	source text of a rule
	pg_get_ruledef(oid, boolean)	postgres	source text of a rule with pretty-print option
	pg_get_serial_sequence(text, text)	postgres	name of sequence for a serial column
	pg_get_triggerdef(oid)	postgres	trigger description
	pg_get_userbyid(oid)	postgres	role name by OID (with fallback)
	pg_get_viewdef(text, boolean)	postgres	select statement of a view with pretty-print option
	pg_get_viewdef(text)	postgres	select statement of a view
	pg_get_viewdef(oid)	postgres	select statement of a view
	pg_get_viewdef(oid, boolean)	postgres	select statement of a view with pretty-print option
	pg_has_role(oid, name, text)	postgres	user privilege on role by user oid, role name
	pg_has_role(oid, text)	postgres	current user privilege on role by role oid
	pg_has_role(name, text)	postgres	current user privilege on role by role name
	pg_has_role(oid, oid, text)	postgres	user privilege on role by user oid, role oid
	pg_has_role(name, oid, text)	postgres	user privilege on role by username, role oid
	pg_has_role(name, name, text)	postgres	user privilege on role by username, role name
	pg_is_other_temp_schema(oid)	postgres	is schema another session's temp schema?
	pg_lock_status()	postgres	view system lock information
	pg_logdir_ls()	postgres
	pg_logfile_rotate()	postgres
	pg_ls_dir(text)	postgres	List all files in a directory
	pg_my_temp_schema()	postgres	get OID of current session's temp schema, if any
	pg_opclass_is_visible(oid)	postgres	is opclass visible in search path?
	pg_operator_is_visible(oid)	postgres	is operator visible in search path?
	pg_postmaster_start_time()	postgres	postmaster start time
	pg_prepared_statement()	postgres	get the prepared statements for this session
	pg_prepared_xact()	postgres	view two-phase transactions
	pg_read_file(text, bigint, bigint)	postgres	Read text from a file
	pg_relation_size(text)	postgres	Calculate disk space usage for the specified table or index
	pg_relation_size(oid)	postgres	Calculate disk space usage for the specified table or index
	pg_reload_conf()	postgres	Reload configuration files
	pg_rotate_logfile()	postgres	Rotate log file
	pg_show_all_settings()	postgres	SHOW ALL as a function
	pg_size_pretty(bigint)	postgres	Convert a long int to a human readable text using size units
	pg_sleep(double precision)	postgres	Sleep for the specified time in seconds
	pg_start_backup(text)	postgres	Prepare for taking an online backup
	pg_stat_get_backend_activity(integer)	postgres	Statistics: Current query of backend
	pg_stat_get_backend_activity_start(integer)	postgres	Statistics: Start time for current query of backend
	pg_stat_get_backend_client_addr(integer)	postgres	Statistics: Address of client connected to backend
	pg_stat_get_backend_client_port(integer)	postgres	Statistics: Port number of client connected to backend
	pg_stat_get_backend_dbid(integer)	postgres	Statistics: Database ID of backend
	pg_stat_get_backend_idset()	postgres	Statistics: Currently active backend IDs
	pg_stat_get_backend_pid(integer)	postgres	Statistics: PID of backend
	pg_stat_get_backend_start(integer)	postgres	Statistics: Start time for current backend session
	pg_stat_get_backend_userid(integer)	postgres	Statistics: User ID of backend
	pg_stat_get_backend_waiting(integer)	postgres	Statistics: Is backend currently waiting for a lock
	pg_stat_get_blocks_fetched(oid)	postgres	Statistics: Number of blocks fetched
	pg_stat_get_blocks_hit(oid)	postgres	Statistics: Number of blocks found in cache
	pg_stat_get_db_blocks_fetched(oid)	postgres	Statistics: Blocks fetched for database
	pg_stat_get_db_blocks_hit(oid)	postgres	Statistics: Blocks found in cache for database
	pg_stat_get_db_numbackends(oid)	postgres	Statistics: Number of backends in database
	pg_stat_get_db_xact_commit(oid)	postgres	Statistics: Transactions committed
	pg_stat_get_db_xact_rollback(oid)	postgres	Statistics: Transactions rolled back
	pg_stat_get_last_analyze_time(oid)	postgres	Statistics: Last manual analyze time for a table
	pg_stat_get_last_autoanalyze_time(oid)	postgres	Statistics: Last auto analyze time for a table
	pg_stat_get_last_autovacuum_time(oid)	postgres	Statistics: Last auto vacuum time for a table
	pg_stat_get_last_vacuum_time(oid)	postgres	Statistics: Last manual vacuum time for a table
	pg_stat_get_numscans(oid)	postgres	Statistics: Number of scans done for table/index
	pg_stat_get_tuples_deleted(oid)	postgres	Statistics: Number of tuples deleted
	pg_stat_get_tuples_fetched(oid)	postgres	Statistics: Number of tuples fetched by idxscan
	pg_stat_get_tuples_inserted(oid)	postgres	Statistics: Number of tuples inserted
	pg_stat_get_tuples_returned(oid)	postgres	Statistics: Number of tuples read by seqscan
	pg_stat_get_tuples_updated(oid)	postgres	Statistics: Number of tuples updated
	pg_stat_reset()	postgres	Statistics: Reset collected statistics
	pg_stop_backup()	postgres	Finish taking an online backup
	pg_switch_xlog()	postgres	Switch to new xlog file
	pg_table_is_visible(oid)	postgres	is table visible in search path?
	pg_tablespace_databases(oid)	postgres	returns database oids in a tablespace
	pg_tablespace_size(name)	postgres	Calculate total disk space usage for the specified tablespace
	pg_tablespace_size(oid)	postgres	Calculate total disk space usage for the specified tablespace
	pg_total_relation_size(text)	postgres	Calculate total disk space usage for the specified table and associated indexes and toast tables
	pg_total_relation_size(oid)	postgres	Calculate total disk space usage for the specified table and associated indexes and toast tables
	pg_try_advisory_lock(integer, integer)	postgres	obtain exclusive advisory lock if available
	pg_try_advisory_lock(bigint)	postgres	obtain exclusive advisory lock if available
	pg_try_advisory_lock_shared(integer, integer)	postgres	obtain shared advisory lock if available
	pg_try_advisory_lock_shared(bigint)	postgres	obtain shared advisory lock if available
	pg_type_is_visible(oid)	postgres	is type visible in search path?
	pg_xlogfile_name(text)	postgres	xlog filename, given an xlog location
	pi()	postgres	PI
	point(lseg)	postgres	center of
	point(double precision, double precision)	postgres	convert x, y to point
	point(circle)	postgres	center of
	point(box)	postgres	center of
	point(path)	postgres	center of
	point(polygon)	postgres	center of
	point_above(point, point)	postgres	is above
	point_add(point, point)	postgres	add points (translate)
	point_below(point, point)	postgres	is below
	point_distance(point, point)	postgres	distance between
	point_div(point, point)	postgres	divide points (scale/rotate)
	point_eq(point, point)	postgres	same as?
	point_horiz(point, point)	postgres	horizontally aligned?
	point_in(cstring)	postgres	I/O
	point_left(point, point)	postgres	is left of
	point_mul(point, point)	postgres	multiply points (scale/rotate)
	point_ne(point, point)	postgres	not equal
	point_out(point)	postgres	I/O
	point_recv(internal)	postgres	I/O
	point_right(point, point)	postgres	is right of
	point_send(point)	postgres	I/O
	point_sub(point, point)	postgres	subtract points (translate)
	point_vert(point, point)	postgres	vertically aligned?
	poly_above(polygon, polygon)	postgres	is above
	poly_below(polygon, polygon)	postgres	is below
	poly_center(polygon)	postgres	center of
	poly_contain(polygon, polygon)	postgres	contains?
	poly_contain_pt(polygon, point)	postgres	polygon contains point?
	poly_contained(polygon, polygon)	postgres	is contained by?
	poly_distance(polygon, polygon)	postgres	distance between
	poly_in(cstring)	postgres	I/O
	poly_left(polygon, polygon)	postgres	is left of
	poly_npoints(polygon)	postgres	number of points in polygon
	poly_out(polygon)	postgres	I/O
	poly_overabove(polygon, polygon)	postgres	overlaps or is above
	poly_overbelow(polygon, polygon)	postgres	overlaps or is below
	poly_overlap(polygon, polygon)	postgres	overlaps
	poly_overleft(polygon, polygon)	postgres	overlaps or is left of
	poly_overright(polygon, polygon)	postgres	overlaps or is right of
	poly_recv(internal)	postgres	I/O
	poly_right(polygon, polygon)	postgres	is right of
	poly_same(polygon, polygon)	postgres	same as?
	poly_send(polygon)	postgres	I/O
	polygon(path)	postgres	convert path to polygon
	polygon(circle)	postgres	convert circle to 12-vertex polygon
	polygon(box)	postgres	convert box to polygon
	polygon(integer, circle)	postgres	convert vertex count and circle to polygon
	popen(path)	postgres	open path
	position(bit, bit)	postgres	return position of sub-bitstring
	position(bytea, bytea)	postgres	return position of substring
	position(text, text)	postgres	return position of substring
	positionjoinsel(internal, oid, internal, smallint)	postgres	join selectivity for position-comparison operators
	positionsel(internal, oid, internal, integer)	postgres	restriction selectivity for position-comparison operators
	pow(double precision, double precision)	postgres	exponentiation
	pow(numeric, numeric)	postgres	m raised to the power of n
	power(numeric, numeric)	postgres	m raised to the power of n
	power(double precision, double precision)	postgres	exponentiation
	pt_contained_circle(point, circle)	postgres	point contained in circle?
	pt_contained_poly(point, polygon)	postgres	point contained in polygon?
	quote_ident(text)	postgres	quote an identifier for usage in a querystring
	quote_literal(text)	postgres	quote a literal for usage in a querystring
	radians(double precision)	postgres	degrees to radians
	radius(circle)	postgres	radius of circle
	random()	postgres	random value
	record_in(cstring, oid, integer)	postgres	I/O
	record_out(record)	postgres	I/O
	record_recv(internal, oid, integer)	postgres	I/O
	record_send(record)	postgres	I/O
	regclass(text)	postgres	convert text to regclass
	regclassin(cstring)	postgres	I/O
	regclassout(regclass)	postgres	I/O
	regclassrecv(internal)	postgres	I/O
	regclasssend(regclass)	postgres	I/O
	regexeqjoinsel(internal, oid, internal, smallint)	postgres	join selectivity of regex match
	regexeqsel(internal, oid, internal, integer)	postgres	restriction selectivity of regex match
	regexnejoinsel(internal, oid, internal, smallint)	postgres	join selectivity of regex non-match
	regexnesel(internal, oid, internal, integer)	postgres	restriction selectivity of regex non-match
	regexp_replace(text, text, text)	postgres	replace text using regexp
	regexp_replace(text, text, text, text)	postgres	replace text using regexp
	regoperatorin(cstring)	postgres	I/O
	regoperatorout(regoperator)	postgres	I/O
	regoperatorrecv(internal)	postgres	I/O
	regoperatorsend(regoperator)	postgres	I/O
	regoperin(cstring)	postgres	I/O
	regoperout(regoper)	postgres	I/O
	regoperrecv(internal)	postgres	I/O
	regopersend(regoper)	postgres	I/O
	regprocedurein(cstring)	postgres	I/O
	regprocedureout(regprocedure)	postgres	I/O
	regprocedurerecv(internal)	postgres	I/O
	regproceduresend(regprocedure)	postgres	I/O
	regprocin(cstring)	postgres	I/O
	regprocout(regproc)	postgres	I/O
	regprocrecv(internal)	postgres	I/O
	regprocsend(regproc)	postgres	I/O
	regtypein(cstring)	postgres	I/O
	regtypeout(regtype)	postgres	I/O
	regtyperecv(internal)	postgres	I/O
	regtypesend(regtype)	postgres	I/O
	reltime(interval)	postgres	convert interval to reltime
	reltimeeq(reltime, reltime)	postgres	equal
	reltimege(reltime, reltime)	postgres	greater-than-or-equal
	reltimegt(reltime, reltime)	postgres	greater-than
	reltimein(cstring)	postgres	I/O
	reltimele(reltime, reltime)	postgres	less-than-or-equal
	reltimelt(reltime, reltime)	postgres	less-than
	reltimene(reltime, reltime)	postgres	not equal
	reltimeout(reltime)	postgres	I/O
	reltimerecv(internal)	postgres	I/O
	reltimesend(reltime)	postgres	I/O
	repeat(text, integer)	postgres	replicate string int4 times
	replace(text, text, text)	postgres	replace all occurrences of old_substr with new_substr in string
	round(double precision)	postgres	round to nearest integer
	round(numeric)	postgres	value rounded to 'scale' of zero
	round(numeric, integer)	postgres	value rounded to 'scale'
	rpad(text, integer)	postgres	right-pad string to length
	rpad(text, integer, text)	postgres	right-pad string to length
	rtrim(text)	postgres	trim spaces from right end of string
	rtrim(text, text)	postgres	trim selected characters from right end of string
	scalargtjoinsel(internal, oid, internal, smallint)	postgres	join selectivity of > and related operators on scalar datatypes
	scalargtsel(internal, oid, internal, integer)	postgres	restriction selectivity of > and related operators on scalar datatypes
	scalarltjoinsel(internal, oid, internal, smallint)	postgres	join selectivity of < and related operators on scalar datatypes
	scalarltsel(internal, oid, internal, integer)	postgres	restriction selectivity of < and related operators on scalar datatypes
	session_user()	postgres	session user name
	set_bit(bytea, integer, integer)	postgres	set bit
	set_byte(bytea, integer, integer)	postgres	set byte
	set_config(text, text, boolean)	postgres	SET X as a function
	set_masklen(inet, integer)	postgres	change netmask of inet
	set_masklen(cidr, integer)	postgres	change netmask of cidr
	setseed(double precision)	postgres	set random seed
	setval(regclass, bigint)	postgres	set sequence value
	setval(regclass, bigint, boolean)	postgres	set sequence value and iscalled status
	shell_in(cstring)	postgres	I/O
	shell_out(opaque)	postgres	I/O
	shobj_description(oid, name)	postgres	get description for object id and shared catalog name
	sign(numeric)	postgres	sign of value
	sign(double precision)	postgres	sign of value
	similar_escape(text, text)	postgres	convert SQL99 regexp pattern to POSIX style
	sin(double precision)	postgres	sine
	sjis_to_euc_jp(integer, integer, cstring, internal, integer)	postgres
	sjis_to_mic(integer, integer, cstring, internal, integer)	postgres
	sjis_to_utf8(integer, integer, cstring, internal, integer)	postgres
	slope(point, point)	postgres	slope between points
	smgreq(smgr, smgr)	postgres	storage manager
	smgrin(cstring)	postgres	I/O
	smgrne(smgr, smgr)	postgres	storage manager
	smgrout(smgr)	postgres	I/O
	split_part(text, text, integer)	postgres	split string by field_sep and return field_num
	sqrt(double precision)	postgres	square root
	sqrt(numeric)	postgres	square root
	statement_timestamp()	postgres	current statement time
	string_to_array(text, text)	postgres	split delimited text into text[]
	strpos(text, text)	postgres	find position of substring
	substr(bytea, integer, integer)	postgres	return portion of string
	substr(text, integer)	postgres	return portion of string
	substr(text, integer, integer)	postgres	return portion of string
	substr(bytea, integer)	postgres	return portion of string
	substring(bytea, integer, integer)	postgres	return portion of string
	substring(bit, integer, integer)	postgres	return portion of bitstring
	substring(bytea, integer)	postgres	return portion of string
	substring(text, integer)	postgres	return portion of string
	substring(text, integer, integer)	postgres	return portion of string
	substring(text, text)	postgres	extracts text matching regular expression
	substring(text, text, text)	postgres	extracts text matching SQL99 regular expression
	substring(bit, integer)	postgres	return portion of bitstring
	tan(double precision)	postgres	tangent
	text(time with time zone)	postgres	convert timetz to text
	text(numeric)	postgres	(internal)
	text(inet)	postgres	show all parts of inet/cidr value
	text(macaddr)	postgres	MAC address to text
	text(timestamp without time zone)	postgres	convert timestamp to text
	text(character)	postgres	convert char(n) to text
	text(name)	postgres	convert name to text
	text(oid)	postgres	convert oid to text
	text(smallint)	postgres	convert int2 to text
	text(integer)	postgres	convert int4 to text
	text(bigint)	postgres	convert int8 to text
	text(interval)	postgres	convert interval to text
	text(timestamp with time zone)	postgres	convert timestamp with time zone to text
	text(time without time zone)	postgres	convert time to text
	text(date)	postgres	convert date to text
	text("char")	postgres	convert char to text
	text(real)	postgres	convert float4 to text
	text(double precision)	postgres	convert float8 to text
	text_ge(text, text)	postgres	greater-than-or-equal
	text_gt(text, text)	postgres	greater-than
	text_larger(text, text)	postgres	larger of two
	text_le(text, text)	postgres	less-than-or-equal
	text_lt(text, text)	postgres	less-than
	text_pattern_eq(text, text)	postgres
	text_pattern_ge(text, text)	postgres
	text_pattern_gt(text, text)	postgres
	text_pattern_le(text, text)	postgres
	text_pattern_lt(text, text)	postgres
	text_pattern_ne(text, text)	postgres
	text_smaller(text, text)	postgres	smaller of two
	textcat(text, text)	postgres	concatenate
	texteq(text, text)	postgres	equal
	texticlike(text, text)	postgres	matches LIKE expression, case-insensitive
	texticnlike(text, text)	postgres	does not match LIKE expression, case-insensitive
	texticregexeq(text, text)	postgres	matches regex., case-insensitive
	texticregexne(text, text)	postgres	does not match regex., case-insensitive
	textin(cstring)	postgres	I/O
	textlen(text)	postgres	length
	textlike(text, text)	postgres	matches LIKE expression
	textne(text, text)	postgres	not equal
	textnlike(text, text)	postgres	does not match LIKE expression
	textout(text)	postgres	I/O
	textrecv(internal)	postgres	I/O
	textregexeq(text, text)	postgres	matches regex., case-sensitive
	textregexne(text, text)	postgres	does not match regex., case-sensitive
	textsend(text)	postgres	I/O
	tideq(tid, tid)	postgres	equal
	tidge(tid, tid)	postgres	greater-than-or-equal
	tidgt(tid, tid)	postgres	greater-than
	tidin(cstring)	postgres	I/O
	tidlarger(tid, tid)	postgres	larger of two
	tidle(tid, tid)	postgres	less-than-or-equal
	tidlt(tid, tid)	postgres	less-than
	tidne(tid, tid)	postgres	not equal
	tidout(tid)	postgres	I/O
	tidrecv(internal)	postgres	I/O
	tidsend(tid)	postgres	I/O
	tidsmaller(tid, tid)	postgres	smaller of two
	time(text)	postgres	convert text to time
	time(time with time zone)	postgres	convert time with time zone to time
	time(timestamp without time zone)	postgres	convert timestamp to time
	time(interval)	postgres	convert interval to time
	time(timestamp with time zone)	postgres	convert timestamptz to time
	time(time without time zone, integer)	postgres	adjust time precision
	time(abstime)	postgres	convert abstime to time
	time_cmp(time without time zone, time without time zone)	postgres	less-equal-greater
	time_eq(time without time zone, time without time zone)	postgres	equal
	time_ge(time without time zone, time without time zone)	postgres	greater-than-or-equal
	time_gt(time without time zone, time without time zone)	postgres	greater-than
	time_in(cstring, oid, integer)	postgres	I/O
	time_larger(time without time zone, time without time zone)	postgres	larger of two
	time_le(time without time zone, time without time zone)	postgres	less-than-or-equal
	time_lt(time without time zone, time without time zone)	postgres	less-than
	time_mi_interval(time without time zone, interval)	postgres	minus
	time_mi_time(time without time zone, time without time zone)	postgres	minus
	time_ne(time without time zone, time without time zone)	postgres	not equal
	time_out(time without time zone)	postgres	I/O
	time_pl_interval(time without time zone, interval)	postgres	plus
	time_recv(internal, oid, integer)	postgres	I/O
	time_send(time without time zone)	postgres	I/O
	time_smaller(time without time zone, time without time zone)	postgres	smaller of two
	timedate_pl(time without time zone, date)	postgres	convert time and date to timestamp
	timemi(abstime, reltime)	postgres	subtract
	timenow()	postgres	Current date and time (abstime)
	timeofday()	postgres	Current date and time - increments during transactions
	timepl(abstime, reltime)	postgres	add
	timestamp(abstime)	postgres	convert abstime to timestamp
	timestamp(date)	postgres	convert date to timestamp
	timestamp(date, time without time zone)	postgres	convert date and time to timestamp
	timestamp(text)	postgres	convert text to timestamp
	timestamp(timestamp without time zone, integer)	postgres	adjust timestamp precision
	timestamp(timestamp with time zone)	postgres	convert timestamp with time zone to timestamp
	timestamp_cmp(timestamp without time zone, timestamp without time zone)	postgres	less-equal-greater
	timestamp_cmp_date(timestamp without time zone, date)	postgres	less-equal-greater
	timestamp_cmp_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	less-equal-greater
	timestamp_eq(timestamp without time zone, timestamp without time zone)	postgres	equal
	timestamp_eq_date(timestamp without time zone, date)	postgres	equal
	timestamp_eq_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	equal
	timestamp_ge(timestamp without time zone, timestamp without time zone)	postgres	greater-than-or-equal
	timestamp_ge_date(timestamp without time zone, date)	postgres	greater-than-or-equal
	timestamp_ge_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	greater-than-or-equal
	timestamp_gt(timestamp without time zone, timestamp without time zone)	postgres	greater-than
	timestamp_gt_date(timestamp without time zone, date)	postgres	greater-than
	timestamp_gt_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	greater-than
	timestamp_in(cstring, oid, integer)	postgres	I/O
	timestamp_larger(timestamp without time zone, timestamp without time zone)	postgres	larger of two
	timestamp_le(timestamp without time zone, timestamp without time zone)	postgres	less-than-or-equal
	timestamp_le_date(timestamp without time zone, date)	postgres	less-than-or-equal
	timestamp_le_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	less-than-or-equal
	timestamp_lt(timestamp without time zone, timestamp without time zone)	postgres	less-than
	timestamp_lt_date(timestamp without time zone, date)	postgres	less-than
	timestamp_lt_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	less-than
	timestamp_mi(timestamp without time zone, timestamp without time zone)	postgres	subtract
	timestamp_mi_interval(timestamp without time zone, interval)	postgres	minus
	timestamp_ne(timestamp without time zone, timestamp without time zone)	postgres	not equal
	timestamp_ne_date(timestamp without time zone, date)	postgres	not equal
	timestamp_ne_timestamptz(timestamp without time zone, timestamp with time zone)	postgres	not equal
	timestamp_out(timestamp without time zone)	postgres	I/O
	timestamp_pl_interval(timestamp without time zone, interval)	postgres	plus
	timestamp_recv(internal, oid, integer)	postgres	I/O
	timestamp_send(timestamp without time zone)	postgres	I/O
	timestamp_smaller(timestamp without time zone, timestamp without time zone)	postgres	smaller of two
	timestamptz(timestamp without time zone)	postgres	convert timestamp to timestamp with time zone
	timestamptz(date)	postgres	convert date to timestamp with time zone
	timestamptz(text)	postgres	convert text to timestamp with time zone
	timestamptz(date, time without time zone)	postgres	convert date and time to timestamp with time zone
	timestamptz(abstime)	postgres	convert abstime to timestamp with time zone
	timestamptz(date, time with time zone)	postgres	convert date and time with time zone to timestamp with time zone
	timestamptz(timestamp with time zone, integer)	postgres	adjust timestamptz precision
	timestamptz_cmp(timestamp with time zone, timestamp with time zone)	postgres	less-equal-greater
	timestamptz_cmp_date(timestamp with time zone, date)	postgres	less-equal-greater
	timestamptz_cmp_timestamp(timestamp with time zone, timestamp without time zone)	postgres	less-equal-greater
	timestamptz_eq(timestamp with time zone, timestamp with time zone)	postgres	equal
	timestamptz_eq_date(timestamp with time zone, date)	postgres	equal
	timestamptz_eq_timestamp(timestamp with time zone, timestamp without time zone)	postgres	equal
	timestamptz_ge(timestamp with time zone, timestamp with time zone)	postgres	greater-than-or-equal
	timestamptz_ge_date(timestamp with time zone, date)	postgres	greater-than-or-equal
	timestamptz_ge_timestamp(timestamp with time zone, timestamp without time zone)	postgres	greater-than-or-equal
	timestamptz_gt(timestamp with time zone, timestamp with time zone)	postgres	greater-than
	timestamptz_gt_date(timestamp with time zone, date)	postgres	greater-than
	timestamptz_gt_timestamp(timestamp with time zone, timestamp without time zone)	postgres	greater-than
	timestamptz_in(cstring, oid, integer)	postgres	I/O
	timestamptz_larger(timestamp with time zone, timestamp with time zone)	postgres	larger of two
	timestamptz_le(timestamp with time zone, timestamp with time zone)	postgres	less-than-or-equal
	timestamptz_le_date(timestamp with time zone, date)	postgres	less-than-or-equal
	timestamptz_le_timestamp(timestamp with time zone, timestamp without time zone)	postgres	less-than-or-equal
	timestamptz_lt(timestamp with time zone, timestamp with time zone)	postgres	less-than
	timestamptz_lt_date(timestamp with time zone, date)	postgres	less-than
	timestamptz_lt_timestamp(timestamp with time zone, timestamp without time zone)	postgres	less-than
	timestamptz_mi(timestamp with time zone, timestamp with time zone)	postgres	subtract
	timestamptz_mi_interval(timestamp with time zone, interval)	postgres	minus
	timestamptz_ne(timestamp with time zone, timestamp with time zone)	postgres	not equal
	timestamptz_ne_date(timestamp with time zone, date)	postgres	not equal
	timestamptz_ne_timestamp(timestamp with time zone, timestamp without time zone)	postgres	not equal
	timestamptz_out(timestamp with time zone)	postgres	I/O
	timestamptz_pl_interval(timestamp with time zone, interval)	postgres	plus
	timestamptz_recv(internal, oid, integer)	postgres	I/O
	timestamptz_send(timestamp with time zone)	postgres	I/O
	timestamptz_smaller(timestamp with time zone, timestamp with time zone)	postgres	smaller of two
	timetz(text)	postgres	convert text to timetz
	timetz(time without time zone)	postgres	convert time to timetz
	timetz(time with time zone, integer)	postgres	adjust time with time zone precision
	timetz(timestamp with time zone)	postgres	convert timestamptz to timetz
	timetz_cmp(time with time zone, time with time zone)	postgres	less-equal-greater
	timetz_eq(time with time zone, time with time zone)	postgres	equal
	timetz_ge(time with time zone, time with time zone)	postgres	greater-than-or-equal
	timetz_gt(time with time zone, time with time zone)	postgres	greater-than
	timetz_hash(time with time zone)	postgres	hash
	timetz_in(cstring, oid, integer)	postgres	I/O
	timetz_larger(time with time zone, time with time zone)	postgres	larger of two
	timetz_le(time with time zone, time with time zone)	postgres	less-than-or-equal
	timetz_lt(time with time zone, time with time zone)	postgres	less-than
	timetz_mi_interval(time with time zone, interval)	postgres	minus
	timetz_ne(time with time zone, time with time zone)	postgres	not equal
	timetz_out(time with time zone)	postgres	I/O
	timetz_pl_interval(time with time zone, interval)	postgres	plus
	timetz_recv(internal, oid, integer)	postgres	I/O
	timetz_send(time with time zone)	postgres	I/O
	timetz_smaller(time with time zone, time with time zone)	postgres	smaller of two
	timetzdate_pl(time with time zone, date)	postgres	convert time with time zone and date to timestamp with time zone
	timezone(text, time with time zone)	postgres	adjust time with time zone to new zone
	timezone(text, timestamp with time zone)	postgres	adjust timestamp to new time zone
	timezone(interval, timestamp with time zone)	postgres	adjust timestamp to new time zone
	timezone(text, timestamp without time zone)	postgres	adjust timestamp to new time zone
	timezone(interval, time with time zone)	postgres	adjust time with time zone to new zone
	timezone(interval, timestamp without time zone)	postgres	adjust timestamp to new time zone
	tinterval(abstime, abstime)	postgres	convert to tinterval
	tintervalct(tinterval, tinterval)	postgres	contains?
	tintervalend(tinterval)	postgres	end of interval
	tintervaleq(tinterval, tinterval)	postgres	equal
	tintervalge(tinterval, tinterval)	postgres	greater-than-or-equal
	tintervalgt(tinterval, tinterval)	postgres	greater-than
	tintervalin(cstring)	postgres	I/O
	tintervalle(tinterval, tinterval)	postgres	less-than-or-equal
	tintervalleneq(tinterval, reltime)	postgres	length equal
	tintervallenge(tinterval, reltime)	postgres	length greater-than-or-equal
	tintervallengt(tinterval, reltime)	postgres	length greater-than
	tintervallenle(tinterval, reltime)	postgres	length less-than-or-equal
	tintervallenlt(tinterval, reltime)	postgres	length less-than
	tintervallenne(tinterval, reltime)	postgres	length not equal to
	tintervallt(tinterval, tinterval)	postgres	less-than
	tintervalne(tinterval, tinterval)	postgres	not equal
	tintervalout(tinterval)	postgres	I/O
	tintervalov(tinterval, tinterval)	postgres	overlaps
	tintervalrecv(internal)	postgres	I/O
	tintervalrel(tinterval)	postgres	tinterval to reltime
	tintervalsame(tinterval, tinterval)	postgres	same as?
	tintervalsend(tinterval)	postgres	I/O
	tintervalstart(tinterval)	postgres	start of interval
	to_ascii(text, name)	postgres	encode text from encoding to ASCII text
	to_ascii(text)	postgres	encode text from DB encoding to ASCII text
	to_ascii(text, integer)	postgres	encode text from encoding to ASCII text
	to_char(interval, text)	postgres	format interval to text
	to_char(numeric, text)	postgres	format numeric to text
	to_char(real, text)	postgres	format float4 to text
	to_char(timestamp with time zone, text)	postgres	format timestamp with time zone to text
	to_char(timestamp without time zone, text)	postgres	format timestamp to text
	to_char(bigint, text)	postgres	format int8 to text
	to_char(integer, text)	postgres	format int4 to text
	to_char(double precision, text)	postgres	format float8 to text
	to_date(text, text)	postgres	convert text to date
	to_hex(integer)	postgres	convert int4 number to hex
	to_hex(bigint)	postgres	convert int8 number to hex
	to_number(text, text)	postgres	convert text to numeric
	to_timestamp(text, text)	postgres	convert text to timestamp with time zone
	to_timestamp(double precision)	postgres	convert UNIX epoch to timestamptz
	transaction_timestamp()	postgres	current transaction time
	translate(text, text, text)	postgres	map a set of character appearing in string
	trigger_out("trigger")	postgres	I/O
	trunc(numeric, integer)	postgres	value truncated to 'scale'
	trunc(numeric)	postgres	value truncated to 'scale' of zero
	trunc(macaddr)	postgres	MAC manufacturer fields
	trunc(double precision)	postgres	truncate to integer
	uhc_to_utf8(integer, integer, cstring, internal, integer)	postgres
	unknownin(cstring)	postgres	I/O
	unknownout("unknown")	postgres	I/O
	unknownrecv(internal)	postgres	I/O
	unknownsend("unknown")	postgres	I/O
	upper(text)	postgres	uppercase
	utf8_to_ascii(integer, integer, cstring, internal, integer)	postgres
	utf8_to_big5(integer, integer, cstring, internal, integer)	postgres
	utf8_to_euc_cn(integer, integer, cstring, internal, integer)	postgres
	utf8_to_euc_jp(integer, integer, cstring, internal, integer)	postgres
	utf8_to_euc_kr(integer, integer, cstring, internal, integer)	postgres
	utf8_to_euc_tw(integer, integer, cstring, internal, integer)	postgres
	utf8_to_gb18030(integer, integer, cstring, internal, integer)	postgres
	utf8_to_gbk(integer, integer, cstring, internal, integer)	postgres
	utf8_to_iso8859(integer, integer, cstring, internal, integer)	postgres
	utf8_to_iso8859_1(integer, integer, cstring, internal, integer)	postgres
	utf8_to_johab(integer, integer, cstring, internal, integer)	postgres
	utf8_to_koi8r(integer, integer, cstring, internal, integer)	postgres
	utf8_to_sjis(integer, integer, cstring, internal, integer)	postgres
	utf8_to_uhc(integer, integer, cstring, internal, integer)	postgres
	utf8_to_win(integer, integer, cstring, internal, integer)	postgres
	varbit(bit varying, integer, boolean)	postgres	adjust varbit() to typmod length
	varbit_in(cstring, oid, integer)	postgres	I/O
	varbit_out(bit varying)	postgres	I/O
	varbit_recv(internal, oid, integer)	postgres	I/O
	varbit_send(bit varying)	postgres	I/O
	varbitcmp(bit varying, bit varying)	postgres	compare
	varbiteq(bit varying, bit varying)	postgres	equal
	varbitge(bit varying, bit varying)	postgres	greater than or equal
	varbitgt(bit varying, bit varying)	postgres	greater than
	varbitle(bit varying, bit varying)	postgres	less than or equal
	varbitlt(bit varying, bit varying)	postgres	less than
	varbitne(bit varying, bit varying)	postgres	not equal
	varchar(name)	postgres	convert name to varchar
	varchar(character varying, integer, boolean)	postgres	adjust varchar() to typmod length
	varcharin(cstring, oid, integer)	postgres	I/O
	varcharout(character varying)	postgres	I/O
	varcharrecv(internal, oid, integer)	postgres	I/O
	varcharsend(character varying)	postgres	I/O
	version()	postgres	PostgreSQL version string
	void_in(cstring)	postgres	I/O
	void_out(void)	postgres	I/O
	width(box)	postgres	box width
	width_bucket(numeric, numeric, numeric, integer)	postgres	bucket number of operand in equidepth histogram
	win1250_to_latin2(integer, integer, cstring, internal, integer)	postgres
	win1250_to_mic(integer, integer, cstring, internal, integer)	postgres
	win1251_to_iso(integer, integer, cstring, internal, integer)	postgres
	win1251_to_koi8r(integer, integer, cstring, internal, integer)	postgres
	win1251_to_mic(integer, integer, cstring, internal, integer)	postgres
	win1251_to_win866(integer, integer, cstring, internal, integer)	postgres
	win866_to_iso(integer, integer, cstring, internal, integer)	postgres
	win866_to_koi8r(integer, integer, cstring, internal, integer)	postgres
	win866_to_mic(integer, integer, cstring, internal, integer)	postgres
	win866_to_win1251(integer, integer, cstring, internal, integer)	postgres
	win_to_utf8(integer, integer, cstring, internal, integer)	postgres
	xideq(xid, xid)	postgres	equal
	xideqint4(xid, integer)	postgres	equal
	xidin(cstring)	postgres	I/O
	xidout(xid)	postgres	I/O
	xidrecv(internal)	postgres	I/O
	xidsend(xid)	postgres	I/O

Total: 1792 function(s)

See Also

Schema overview