blob: 6d477761cf58213b82e607122a2ee4ea1c385c52 (plain)

ofs	hex dump	ascii
0000	99 4e 0d 0a e5 7e a1 34 63 00 00 00 00 01 00 00 00 73 fb 00 00 00 7f 00 00 7f 05 00 64 00 00 47	.N...~.4c........s..........d..G
0020	48 7f 06 00 48 7f 07 00 64 01 00 47 48 7f 08 00 48 7f 09 00 64 02 00 47 48 7f 0a 00 48 7f 0b 00	H...H...d..GH...H...d..GH...H...
0040	64 03 00 47 48 7f 0c 00 64 04 00 47 48 7f 0d 00 64 05 00 47 48 7f 0e 00 48 7f 0f 00 64 06 00 47	d..GH...d..GH...d..GH...H...d..G
0060	48 7f 10 00 48 7f 11 00 64 07 00 47 48 7f 12 00 64 08 00 47 48 7f 13 00 64 00 00 47 48 7f 14 00	H...H...d..GH...d..GH...d..GH...
0080	48 7f 16 00 6b 00 00 6c 01 00 01 7f 17 00 6b 02 00 6c 01 00 01 7f 1a 00 64 09 00 84 00 00 5a 03	H...k..l......k..l......d.....Z.
00a0	00 7f 25 00 64 0a 00 84 00 00 5a 04 00 7f 2f 00 64 0b 00 84 00 00 5a 05 00 7f 38 00 64 0c 00 84	..%.d.....Z.../.d.....Z...8.d...
00c0	00 00 5a 06 00 7f 41 00 64 0d 00 84 00 00 5a 07 00 7f 4a 00 64 0e 00 84 00 00 5a 08 00 7f 54 00	..Z...A.d.....Z...J.d.....Z...T.
00e0	64 0f 00 84 00 00 5a 09 00 7f 5c 00 64 10 00 84 00 00 5a 0a 00 7f 64 00 64 11 00 84 00 00 5a 0b	d.....Z...\.d.....Z...d.d.....Z.
0100	00 7f 6c 00 64 12 00 84 00 00 5a 0c 00 64 13 00 53 28 14 00 00 00 73 44 00 00 00 5f 5f 5f 5f 5f	..l.d.....Z..d..S(....sD..._____
0120	5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f	________________________________
0140	5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 5f 73	_______________________________s
0160	39 00 00 00 4d 4f 44 55 4c 45 20 53 59 53 43 41 54 2e 50 59 20 3a 20 50 41 52 53 45 53 20 53 4f	9...MODULE.SYSCAT.PY.:.PARSES.SO
0180	4d 45 20 50 4f 53 54 47 52 45 53 51 4c 20 53 59 53 54 45 4d 20 43 41 54 41 4c 4f 47 53 73 3d 00	ME.POSTGRESQL.SYSTEM.CATALOGSs=.
01a0	00 00 54 68 69 73 20 6d 6f 64 75 6c 65 20 69 73 20 64 65 73 69 67 6e 65 64 20 66 6f 72 20 62 65	..This.module.is.designed.for.be
01c0	69 6e 67 20 69 6d 70 6f 72 74 65 64 20 66 72 6f 6d 20 70 79 74 68 6f 6e 20 70 72 6f 6d 70 74 73	ing.imported.from.python.prompts
01e0	44 00 00 00 49 6e 20 6f 72 64 65 72 20 74 6f 20 72 75 6e 20 74 68 65 20 73 61 6d 70 6c 65 73 20	D...In.order.to.run.the.samples.
0200	69 6e 63 6c 75 64 65 64 20 68 65 72 65 2c 20 66 69 72 73 74 20 63 72 65 61 74 65 20 61 20 63 6f	included.here,.first.create.a.co
0220	6e 6e 65 63 74 69 6f 6e 73 38 00 00 00 75 73 69 6e 67 20 3a 20 20 20 20 20 20 20 20 20 20 20 20	nnections8...using.:............
0240	20 20 20 20 20 20 20 20 20 20 20 20 63 6e 78 20 3d 20 73 79 73 63 61 74 2e 63 6f 6e 6e 65 63 74	............cnx.=.syscat.connect
0260	28 2e 2e 2e 29 73 2f 00 00 00 74 68 65 6e 20 73 74 61 72 74 20 74 68 65 20 64 65 6d 6f 20 77 69	(...)s/...then.start.the.demo.wi
0280	74 68 3a 20 20 20 20 20 20 73 79 73 63 61 74 2e 64 65 6d 6f 28 63 6e 78 29 73 39 00 00 00 53 6f	th:......syscat.demo(cnx)s9...So
02a0	6d 65 20 72 65 73 75 6c 74 73 20 6d 61 79 20 62 65 20 65 6d 70 74 79 2c 20 64 65 70 65 6e 64 69	me.results.may.be.empty,.dependi
02c0	6e 67 20 6f 6e 20 79 6f 75 72 20 62 61 73 65 20 73 74 61 74 75 73 2e 73 41 00 00 00 49 66 20 79	ng.on.your.base.status.sA...If.y
02e0	6f 75 20 77 61 6e 74 20 74 6f 20 61 64 6a 75 73 74 20 74 68 65 20 64 69 73 70 6c 61 79 20 74 6f	ou.want.to.adjust.the.display.to
0300	20 79 6f 75 72 20 73 63 72 65 65 6e 20 73 69 7a 65 20 28 72 6f 77 73 29 2c 20 79 6f 75 73 37 00	.your.screen.size.(rows),.yous7.
0320	00 00 63 61 6e 20 74 79 70 65 3a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	..can.type:.....................
0340	20 73 79 73 63 61 74 2e 73 72 63 5f 73 69 7a 65 20 3d 20 5b 72 6f 77 73 5d 63 01 00 02 00 02 00	.syscat.src_size.=.[rows]c......
0360	03 00 73 20 00 00 00 7f 1a 00 7f 1b 00 7c 00 00 69 01 00 64 01 00 83 01 00 7d 01 00 7f 22 00 7c	..s..........|..i..d.....}...".|
0380	01 00 53 64 00 00 53 28 02 00 00 00 4e 73 2b 01 00 00 73 65 6c 65 63 74 20 62 63 2e 72 65 6c 6e	..Sd..S(....Ns+...select.bc.reln
03a0	61 6d 65 20 61 73 20 63 6c 61 73 73 5f 6e 61 6d 65 2c 20 69 63 2e 72 65 6c 6e 61 6d 65 20 61 73	ame.as.class_name,.ic.relname.as
03c0	20 69 6e 64 65 78 5f 6e 61 6d 65 2c 20 61 2e 61 74 74 6e 61 6d 65 20 66 72 6f 6d 20 70 67 5f 63	.index_name,.a.attname.from.pg_c
03e0	6c 61 73 73 20 62 63 2c 20 70 67 5f 63 6c 61 73 73 20 69 63 2c 20 70 67 5f 69 6e 64 65 78 20 69	lass.bc,.pg_class.ic,.pg_index.i
0400	2c 20 70 67 5f 61 74 74 72 69 62 75 74 65 20 61 20 77 68 65 72 65 20 69 2e 69 6e 64 72 65 6c 69	,.pg_attribute.a.where.i.indreli
0420	64 20 3d 20 62 63 2e 6f 69 64 20 61 6e 64 20 69 2e 69 6e 64 65 78 72 65 6c 69 64 20 3d 20 62 63	d.=.bc.oid.and.i.indexrelid.=.bc
0440	2e 6f 69 64 20 20 20 61 6e 64 20 69 2e 69 6e 64 6b 65 79 5b 30 5d 20 3d 20 61 2e 61 74 74 6e 75	.oid...and.i.indkey[0].=.a.attnu
0460	6d 20 61 6e 64 20 61 2e 61 74 74 72 65 6c 69 64 20 3d 20 62 63 2e 6f 69 64 20 20 20 61 6e 64 20	m.and.a.attrelid.=.bc.oid...and.
0480	69 2e 69 6e 64 70 72 6f 63 20 3d 20 27 30 27 3a 3a 6f 69 64 20 6f 72 64 65 72 20 62 79 20 63 6c	i.indproc.=.'0'::oid.order.by.cl
04a0	61 73 73 5f 6e 61 6d 65 2c 20 69 6e 64 65 78 5f 6e 61 6d 65 2c 20 61 74 74 6e 61 6d 65 28 03 00	ass_name,.index_name,.attname(..
04c0	00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65 73 75 6c	..s....pgcnxs....querys....resul
04e0	74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09 00 00 00	t(....s....pgcnxs....results....
0500	73 79 73 63 61 74 2e 70 79 73 0f 00 00 00 6c 69 73 74 5f 73 69 6d 70 6c 65 5f 69 6e 64 1a 00 73	syscat.pys....list_simple_ind..s
0520	04 00 00 00 03 01 12 07 63 01 00 02 00 02 00 03 00 73 20 00 00 00 7f 25 00 7f 26 00 7c 00 00 69	........c........s.....%..&.|..i
0540	01 00 64 01 00 83 01 00 7d 01 00 7f 2c 00 7c 01 00 53 64 00 00 53 28 02 00 00 00 4e 73 f4 00 00	..d.....}...,.|..Sd..S(....Ns...
0560	00 73 65 6c 65 63 74 20 63 2e 72 65 6c 6e 61 6d 65 2c 20 61 2e 61 74 74 6e 61 6d 65 2c 20 74 2e	.select.c.relname,.a.attname,.t.
0580	74 79 70 6e 61 6d 65 20 66 72 6f 6d 20 70 67 5f 63 6c 61 73 73 20 63 2c 20 70 67 5f 61 74 74 72	typname.from.pg_class.c,.pg_attr
05a0	69 62 75 74 65 20 61 2c 20 70 67 5f 74 79 70 65 20 74 20 77 68 65 72 65 20 63 2e 72 65 6c 6b 69	ibute.a,.pg_type.t.where.c.relki
05c0	6e 64 20 3d 20 27 72 27 20 61 6e 64 20 63 2e 72 65 6c 6e 61 6d 65 20 21 7e 20 27 5e 70 67 5f 27	nd.=.'r'.and.c.relname.!~.'^pg_'
05e0	20 20 20 61 6e 64 20 63 2e 72 65 6c 6e 61 6d 65 20 21 7e 20 27 5e 49 6e 76 27 20 61 6e 64 20 61	...and.c.relname.!~.'^Inv'.and.a
0600	2e 61 74 74 6e 75 6d 20 3e 20 30 20 20 20 61 6e 64 20 61 2e 61 74 74 72 65 6c 69 64 20 3d 20 63	.attnum.>.0...and.a.attrelid.=.c
0620	2e 6f 69 64 20 61 6e 64 20 61 2e 61 74 74 74 79 70 69 64 20 3d 20 74 2e 6f 69 64 20 6f 72 64 65	.oid.and.a.atttypid.=.t.oid.orde
0640	72 20 62 79 20 72 65 6c 6e 61 6d 65 2c 20 61 74 74 6e 61 6d 65 28 03 00 00 00 73 05 00 00 00 70	r.by.relname,.attname(....s....p
0660	67 63 6e 78 73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65 73 75 6c 74 28 02 00 00 00 73 05	gcnxs....querys....result(....s.
0680	00 00 00 70 67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09 00 00 00 73 79 73 63 61 74 2e 70	...pgcnxs....results....syscat.p
06a0	79 73 0d 00 00 00 6c 69 73 74 5f 61 6c 6c 5f 61 74 74 72 25 00 73 04 00 00 00 03 01 12 06 63 01	ys....list_all_attr%.s........c.
06c0	00 02 00 02 00 03 00 73 20 00 00 00 7f 2f 00 7f 30 00 7c 00 00 69 01 00 64 01 00 83 01 00 7d 01	.......s...../..0.|..i..d.....}.
06e0	00 7f 35 00 7c 01 00 53 64 00 00 53 28 02 00 00 00 4e 73 d1 00 00 00 73 65 6c 65 63 74 20 75 2e	..5.|..Sd..S(....Ns....select.u.
0700	75 73 65 6e 61 6d 65 2c 20 74 2e 74 79 70 6e 61 6d 65 20 66 72 6f 6d 20 70 67 5f 74 79 70 65 20	usename,.t.typname.from.pg_type.
0720	74 2c 20 70 67 5f 75 73 65 72 20 75 20 77 68 65 72 65 20 75 2e 75 73 65 73 79 73 69 64 20 3d 20	t,.pg_user.u.where.u.usesysid.=.
0740	69 6e 74 32 69 6e 28 69 6e 74 34 6f 75 74 28 74 2e 74 79 70 6f 77 6e 65 72 29 29 20 20 20 61 6e	int2in(int4out(t.typowner))...an
0760	64 20 74 2e 74 79 70 72 65 6c 69 64 20 3d 20 27 30 27 3a 3a 6f 69 64 20 61 6e 64 20 74 2e 74 79	d.t.typrelid.=.'0'::oid.and.t.ty
0780	70 65 6c 65 6d 20 3d 20 27 30 27 3a 3a 6f 69 64 20 20 20 61 6e 64 20 75 2e 75 73 65 6e 61 6d 65	pelem.=.'0'::oid...and.u.usename
07a0	20 3c 3e 20 27 70 6f 73 74 67 72 65 73 27 20 6f 72 64 65 72 20 62 79 20 75 73 65 6e 61 6d 65 2c	.<>.'postgres'.order.by.usename,
07c0	20 74 79 70 6e 61 6d 65 28 03 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72	.typname(....s....pgcnxs....quer
07e0	79 73 06 00 00 00 72 65 73 75 6c 74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 06 00 00 00	ys....result(....s....pgcnxs....
0800	72 65 73 75 6c 74 73 09 00 00 00 73 79 73 63 61 74 2e 70 79 73 13 00 00 00 6c 69 73 74 5f 75 73	results....syscat.pys....list_us
0820	65 72 5f 62 61 73 65 5f 74 79 70 65 2f 00 73 04 00 00 00 03 01 12 05 63 01 00 02 00 02 00 03 00	er_base_type/.s........c........
0840	73 20 00 00 00 7f 38 00 7f 39 00 7c 00 00 69 01 00 64 01 00 83 01 00 7d 01 00 7f 3e 00 7c 01 00	s.....8..9.|..i..d.....}...>.|..
0860	53 64 00 00 53 28 02 00 00 00 4e 73 e1 00 00 00 73 65 6c 65 63 74 20 6f 2e 6f 70 72 6e 61 6d 65	Sd..S(....Ns....select.o.oprname
0880	20 61 73 20 72 69 67 68 74 5f 75 6e 61 72 79 2c 20 20 20 6c 74 2e 74 79 70 6e 61 6d 65 20 61 73	.as.right_unary,...lt.typname.as
08a0	20 6f 70 65 72 61 6e 64 2c 20 72 65 73 75 6c 74 2e 74 79 70 6e 61 6d 65 20 61 73 20 72 65 74 75	.operand,.result.typname.as.retu
08c0	72 6e 5f 74 79 70 65 20 66 72 6f 6d 20 70 67 5f 6f 70 65 72 61 74 6f 72 20 6f 2c 20 70 67 5f 74	rn_type.from.pg_operator.o,.pg_t
08e0	79 70 65 20 6c 74 2c 20 70 67 5f 74 79 70 65 20 72 65 73 75 6c 74 20 77 68 65 72 65 20 6f 2e 6f	ype.lt,.pg_type.result.where.o.o
0900	70 72 6b 69 6e 64 3d 27 72 27 20 61 6e 64 20 6f 2e 6f 70 72 6c 65 66 74 20 3d 20 6c 74 2e 6f 69	prkind='r'.and.o.oprleft.=.lt.oi
0920	64 20 20 20 61 6e 64 20 6f 2e 6f 70 72 72 65 73 75 6c 74 20 3d 20 72 65 73 75 6c 74 2e 6f 69 64	d...and.o.oprresult.=.result.oid
0940	20 6f 72 64 65 72 20 62 79 20 6f 70 65 72 61 6e 64 28 03 00 00 00 73 05 00 00 00 70 67 63 6e 78	.order.by.operand(....s....pgcnx
0960	73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65 73 75 6c 74 28 02 00 00 00 73 05 00 00 00 70	s....querys....result(....s....p
0980	67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09 00 00 00 73 79 73 63 61 74 2e 70 79 73 19 00	gcnxs....results....syscat.pys..
09a0	00 00 6c 69 73 74 5f 72 69 67 68 74 5f 75 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 38 00 73 04 00	..list_right_unary_operator8.s..
09c0	00 00 03 01 12 05 63 01 00 02 00 02 00 03 00 73 20 00 00 00 7f 41 00 7f 42 00 7c 00 00 69 01 00	......c........s.....A..B.|..i..
09e0	64 01 00 83 01 00 7d 01 00 7f 47 00 7c 01 00 53 64 00 00 53 28 02 00 00 00 4e 73 e1 00 00 00 73	d.....}...G.|..Sd..S(....Ns....s
0a00	65 6c 65 63 74 20 6f 2e 6f 70 72 6e 61 6d 65 20 61 73 20 6c 65 66 74 5f 75 6e 61 72 79 2c 20 20	elect.o.oprname.as.left_unary,..
0a20	20 72 74 2e 74 79 70 6e 61 6d 65 20 61 73 20 6f 70 65 72 61 6e 64 2c 20 72 65 73 75 6c 74 2e 74	.rt.typname.as.operand,.result.t
0a40	79 70 6e 61 6d 65 20 61 73 20 72 65 74 75 72 6e 5f 74 79 70 65 20 66 72 6f 6d 20 70 67 5f 6f 70	ypname.as.return_type.from.pg_op
0a60	65 72 61 74 6f 72 20 6f 2c 20 70 67 5f 74 79 70 65 20 72 74 2c 20 70 67 5f 74 79 70 65 20 72 65	erator.o,.pg_type.rt,.pg_type.re
0a80	73 75 6c 74 20 77 68 65 72 65 20 6f 2e 6f 70 72 6b 69 6e 64 3d 27 6c 27 20 61 6e 64 20 6f 2e 6f	sult.where.o.oprkind='l'.and.o.o
0aa0	70 72 72 69 67 68 74 20 3d 20 72 74 2e 6f 69 64 20 20 20 61 6e 64 20 6f 2e 6f 70 72 72 65 73 75	prright.=.rt.oid...and.o.oprresu
0ac0	6c 74 20 3d 20 72 65 73 75 6c 74 2e 6f 69 64 20 6f 72 64 65 72 20 62 79 20 6f 70 65 72 61 6e 64	lt.=.result.oid.order.by.operand
0ae0	28 03 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65	(....s....pgcnxs....querys....re
0b00	73 75 6c 74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09	sult(....s....pgcnxs....results.
0b20	00 00 00 73 79 73 63 61 74 2e 70 79 73 18 00 00 00 6c 69 73 74 5f 6c 65 66 74 5f 75 6e 61 72 79	...syscat.pys....list_left_unary
0b40	5f 6f 70 65 72 61 74 6f 72 41 00 73 04 00 00 00 03 01 12 05 63 01 00 02 00 02 00 03 00 73 20 00	_operatorA.s........c........s..
0b60	00 00 7f 4a 00 7f 4b 00 7c 00 00 69 01 00 64 01 00 83 01 00 7d 01 00 7f 51 00 7c 01 00 53 64 00	...J..K.|..i..d.....}...Q.|..Sd.
0b80	00 53 28 02 00 00 00 4e 73 10 01 00 00 73 65 6c 65 63 74 20 6f 2e 6f 70 72 6e 61 6d 65 20 61 73	.S(....Ns....select.o.oprname.as
0ba0	20 62 69 6e 61 72 79 5f 6f 70 2c 20 20 20 72 74 2e 74 79 70 6e 61 6d 65 20 61 73 20 72 69 67 68	.binary_op,...rt.typname.as.righ
0bc0	74 5f 6f 70 72 2c 20 6c 74 2e 74 79 70 6e 61 6d 65 20 61 73 20 6c 65 66 74 5f 6f 70 72 2c 20 20	t_opr,.lt.typname.as.left_opr,..
0be0	20 72 65 73 75 6c 74 2e 74 79 70 6e 61 6d 65 20 61 73 20 72 65 74 75 72 6e 5f 74 79 70 65 20 66	.result.typname.as.return_type.f
0c00	72 6f 6d 20 70 67 5f 6f 70 65 72 61 74 6f 72 20 6f 2c 20 70 67 5f 74 79 70 65 20 72 74 2c 20 70	rom.pg_operator.o,.pg_type.rt,.p
0c20	67 5f 74 79 70 65 20 6c 74 2c 20 70 67 5f 74 79 70 65 20 72 65 73 75 6c 74 20 77 68 65 72 65 20	g_type.lt,.pg_type.result.where.
0c40	6f 2e 6f 70 72 6b 69 6e 64 20 3d 20 27 62 27 20 61 6e 64 20 6f 2e 6f 70 72 72 69 67 68 74 20 3d	o.oprkind.=.'b'.and.o.oprright.=
0c60	20 72 74 2e 6f 69 64 20 20 20 61 6e 64 20 6f 2e 6f 70 72 6c 65 66 74 20 3d 20 6c 74 2e 6f 69 64	.rt.oid...and.o.oprleft.=.lt.oid
0c80	20 61 6e 64 20 6f 2e 6f 70 72 72 65 73 75 6c 74 20 3d 20 72 65 73 75 6c 74 2e 6f 69 64 28 03 00	.and.o.oprresult.=.result.oid(..
0ca0	00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65 73 75 6c	..s....pgcnxs....querys....resul
0cc0	74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09 00 00 00	t(....s....pgcnxs....results....
0ce0	73 79 73 63 61 74 2e 70 79 73 14 00 00 00 6c 69 73 74 5f 62 69 6e 61 72 79 5f 6f 70 65 72 61 74	syscat.pys....list_binary_operat
0d00	6f 72 4a 00 73 04 00 00 00 03 01 12 06 63 02 00 03 00 03 00 03 00 73 24 00 00 00 7f 54 00 7f 55	orJ.s........c........s$....T..U
0d20	00 7c 00 00 69 01 00 64 01 00 7c 01 00 16 83 01 00 7d 02 00 7f 59 00 7c 02 00 53 64 00 00 53 28	.|..i..d..|......}...Y.|..Sd..S(
0d40	02 00 00 00 4e 73 a9 00 00 00 73 65 6c 65 63 74 20 70 2e 70 72 6f 6e 61 6d 65 2c 20 70 2e 70 72	....Ns....select.p.proname,.p.pr
0d60	6f 6e 61 72 67 73 2c 20 74 2e 74 79 70 6e 61 6d 65 20 66 72 6f 6d 20 70 67 5f 70 72 6f 63 20 70	onargs,.t.typname.from.pg_proc.p
0d80	2c 20 70 67 5f 6c 61 6e 67 75 61 67 65 20 6c 2c 20 70 67 5f 74 79 70 65 20 74 20 77 68 65 72 65	,.pg_language.l,.pg_type.t.where
0da0	20 70 2e 70 72 6f 6c 61 6e 67 20 3d 20 6c 2e 6f 69 64 20 61 6e 64 20 70 2e 70 72 6f 72 65 74 74	.p.prolang.=.l.oid.and.p.prorett
0dc0	79 70 65 20 3d 20 74 2e 6f 69 64 20 20 20 61 6e 64 20 6c 2e 6c 61 6e 6e 61 6d 65 20 3d 20 27 25	ype.=.t.oid...and.l.lanname.=.'%
0de0	73 27 20 6f 72 64 65 72 20 62 79 20 70 72 6f 6e 61 6d 65 28 04 00 00 00 73 05 00 00 00 70 67 63	s'.order.by.proname(....s....pgc
0e00	6e 78 73 05 00 00 00 71 75 65 72 79 73 01 00 00 00 6c 73 06 00 00 00 72 65 73 75 6c 74 28 03 00	nxs....querys....ls....result(..
0e20	00 00 73 05 00 00 00 70 67 63 6e 78 73 01 00 00 00 6c 73 06 00 00 00 72 65 73 75 6c 74 73 09 00	..s....pgcnxs....ls....results..
0e40	00 00 73 79 73 63 61 74 2e 70 79 73 0e 00 00 00 6c 69 73 74 5f 6c 61 6e 67 5f 66 75 6e 63 54 00	..syscat.pys....list_lang_funcT.
0e60	73 04 00 00 00 03 01 16 04 63 01 00 02 00 02 00 03 00 73 20 00 00 00 7f 5c 00 7f 5d 00 7c 00 00	s........c........s.....\..].|..
0e80	69 01 00 64 01 00 83 01 00 7d 01 00 7f 60 00 7c 01 00 53 64 00 00 53 28 02 00 00 00 4e 73 70 00	i..d.....}...`.|..Sd..S(....Nsp.
0ea0	00 00 73 65 6c 65 63 74 20 61 2e 61 67 67 6e 61 6d 65 2c 20 74 2e 74 79 70 6e 61 6d 65 20 66 72	..select.a.aggname,.t.typname.fr
0ec0	6f 6d 20 70 67 5f 61 67 67 72 65 67 61 74 65 20 61 2c 20 70 67 5f 74 79 70 65 20 74 20 77 68 65	om.pg_aggregate.a,.pg_type.t.whe
0ee0	72 65 20 61 2e 61 67 67 62 61 73 65 74 79 70 65 20 3d 20 74 2e 6f 69 64 20 6f 72 64 65 72 20 62	re.a.aggbasetype.=.t.oid.order.b
0f00	79 20 61 67 67 6e 61 6d 65 2c 20 74 79 70 6e 61 6d 65 28 03 00 00 00 73 05 00 00 00 70 67 63 6e	y.aggname,.typname(....s....pgcn
0f20	78 73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65 73 75 6c 74 28 02 00 00 00 73 05 00 00 00	xs....querys....result(....s....
0f40	70 67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09 00 00 00 73 79 73 63 61 74 2e 70 79 73 0d	pgcnxs....results....syscat.pys.
0f60	00 00 00 6c 69 73 74 5f 61 67 67 5f 66 75 6e 63 5c 00 73 04 00 00 00 03 01 12 03 63 01 00 02 00	...list_agg_func\.s........c....
0f80	02 00 03 00 73 20 00 00 00 7f 64 00 7f 65 00 7c 00 00 69 01 00 64 01 00 83 01 00 7d 01 00 7f 69	....s.....d..e.|..i..d.....}...i
0fa0	00 7c 01 00 53 64 00 00 53 28 02 00 00 00 4e 73 de 00 00 00 73 65 6c 65 63 74 20 61 6d 2e 61 6d	.|..Sd..S(....Ns....select.am.am
0fc0	6e 61 6d 65 2c 20 6f 70 63 2e 6f 70 63 6e 61 6d 65 2c 20 6f 70 72 2e 6f 70 72 6e 61 6d 65 20 66	name,.opc.opcname,.opr.oprname.f
0fe0	72 6f 6d 20 70 67 5f 61 6d 20 61 6d 2c 20 70 67 5f 61 6d 6f 70 20 61 6d 6f 70 2c 20 70 67 5f 6f	rom.pg_am.am,.pg_amop.amop,.pg_o
1000	70 63 6c 61 73 73 20 6f 70 63 2c 20 70 67 5f 6f 70 65 72 61 74 6f 72 20 6f 70 72 20 77 68 65 72	pclass.opc,.pg_operator.opr.wher
1020	65 20 61 6d 6f 70 2e 61 6d 6f 70 69 64 20 3d 20 61 6d 2e 6f 69 64 20 61 6e 64 20 61 6d 6f 70 2e	e.amop.amopid.=.am.oid.and.amop.
1040	61 6d 6f 70 63 6c 61 69 64 20 3d 20 6f 70 63 2e 6f 69 64 20 20 20 61 6e 64 20 61 6d 6f 70 2e 61	amopclaid.=.opc.oid...and.amop.a
1060	6d 6f 70 6f 70 72 20 3d 20 6f 70 72 2e 6f 69 64 20 6f 72 64 65 72 20 62 79 20 61 6d 6e 61 6d 65	mopopr.=.opr.oid.order.by.amname
1080	2c 20 6f 70 63 6e 61 6d 65 2c 20 6f 70 72 6e 61 6d 65 28 03 00 00 00 73 05 00 00 00 70 67 63 6e	,.opcname,.oprname(....s....pgcn
10a0	78 73 05 00 00 00 71 75 65 72 79 73 06 00 00 00 72 65 73 75 6c 74 28 02 00 00 00 73 05 00 00 00	xs....querys....result(....s....
10c0	70 67 63 6e 78 73 06 00 00 00 72 65 73 75 6c 74 73 09 00 00 00 73 79 73 63 61 74 2e 70 79 73 0d	pgcnxs....results....syscat.pys.
10e0	00 00 00 6c 69 73 74 5f 6f 70 5f 63 6c 61 73 73 64 00 73 04 00 00 00 03 01 12 04 63 01 00 02 00	...list_op_classd.s........c....
1100	03 00 03 00 73 41 02 00 00 7f 6c 00 7f 6d 00 64 01 00 47 48 7f 6e 00 74 00 00 7c 00 00 83 01 00	....sA....l..m.d..GH.n.t..|.....
1120	7d 01 00 7f 6f 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f	}...o.t..|..i.....|..i..........
1140	70 00 64 02 00 47 48 7f 71 00 74 06 00 7c 00 00 83 01 00 7d 01 00 7f 72 00 74 03 00 7c 01 00 69	p.d..GH.q.t..|.....}...r.t..|..i
1160	04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f 73 00 64 03 00 47 48 7f 74 00 74 07 00	.....|..i..........s.d..GH.t.t..
1180	7c 00 00 83 01 00 7d 01 00 7f 75 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00	|.....}...u.t..|..i.....|..i....
11a0	00 83 02 00 01 7f 76 00 64 04 00 47 48 7f 77 00 74 08 00 7c 00 00 83 01 00 7d 01 00 7f 78 00 74	......v.d..GH.w.t..|.....}...x.t
11c0	03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f 79 00 64 05 00 47 48	..|..i.....|..i..........y.d..GH
11e0	7f 7a 00 74 09 00 7c 00 00 83 01 00 7d 01 00 7f 7b 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01	.z.t..|.....}...{.t..|..i.....|.
1200	00 69 05 00 83 00 00 83 02 00 01 7f 7c 00 64 06 00 47 48 7f 7d 00 74 0a 00 7c 00 00 83 01 00 7d	.i..........|.d..GH.}.t..|.....}
1220	01 00 7f 7e 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f 7f	...~.t..|..i.....|..i...........
1240	00 64 07 00 47 48 7f 80 00 74 0b 00 7c 00 00 64 08 00 83 02 00 7d 01 00 7f 81 00 74 03 00 7c 01	.d..GH...t..|..d.....}.....t..|.
1260	00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f 82 00 64 09 00 47 48 7f 83 00 74	.i.....|..i............d..GH...t
1280	0b 00 7c 00 00 64 0a 00 83 02 00 7d 01 00 7f 84 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00	..|..d.....}.....t..|..i.....|..
12a0	69 05 00 83 00 00 83 02 00 01 7f 85 00 64 0b 00 47 48 7f 86 00 74 0b 00 7c 00 00 64 0c 00 83 02	i............d..GH...t..|..d....
12c0	00 7d 01 00 7f 87 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01	.}.....t..|..i.....|..i.........
12e0	7f 88 00 64 0d 00 47 48 7f 89 00 74 0c 00 7c 00 00 83 01 00 7d 01 00 7f 8a 00 74 03 00 7c 01 00	...d..GH...t..|.....}.....t..|..
1300	69 04 00 83 00 00 7c 01 00 69 05 00 83 00 00 83 02 00 01 7f 8b 00 64 0e 00 47 48 7f 8c 00 74 0d	i.....|..i............d..GH...t.
1320	00 7c 00 00 83 01 00 7d 01 00 7f 8d 00 74 03 00 7c 01 00 69 04 00 83 00 00 7c 01 00 69 05 00 83	.|.....}.....t..|..i.....|..i...
1340	00 00 83 02 00 01 64 00 00 53 28 0f 00 00 00 4e 73 1a 00 00 00 4c 69 73 74 69 6e 67 20 73 69 6d	......d..S(....Ns....Listing.sim
1360	70 6c 65 20 69 6e 64 69 63 65 73 20 2e 2e 2e 73 1a 00 00 00 4c 69 73 74 69 6e 67 20 61 6c 6c 20	ple.indices....s....Listing.all.
1380	61 74 74 72 69 62 75 74 65 73 20 2e 2e 2e 73 27 00 00 00 4c 69 73 74 69 6e 67 20 61 6c 6c 20 75	attributes....s'...Listing.all.u
13a0	73 65 72 2d 64 65 66 69 6e 65 64 20 62 61 73 65 20 74 79 70 65 73 20 2e 2e 2e 73 2c 00 00 00 4c	ser-defined.base.types....s,...L
13c0	69 73 74 69 6e 67 20 61 6c 6c 20 6c 65 66 74 2d 75 6e 61 72 79 20 6f 70 65 72 61 74 6f 72 73 20	isting.all.left-unary.operators.
13e0	64 65 66 69 6e 65 64 20 2e 2e 2e 73 2d 00 00 00 4c 69 73 74 69 6e 67 20 61 6c 6c 20 72 69 67 68	defined....s-...Listing.all.righ
1400	74 2d 75 6e 61 72 79 20 6f 70 65 72 61 74 6f 72 73 20 64 65 66 69 6e 65 64 20 2e 2e 2e 73 20 00	t-unary.operators.defined....s..
1420	00 00 4c 69 73 74 69 6e 67 20 61 6c 6c 20 62 69 6e 61 72 79 20 6f 70 65 72 61 74 6f 72 73 20 2e	..Listing.all.binary.operators..
1440	2e 2e 73 26 00 00 00 4c 69 73 74 69 6e 67 20 43 20 65 78 74 65 72 6e 61 6c 20 66 75 6e 63 74 69	..s&...Listing.C.external.functi
1460	6f 6e 20 6c 69 6e 6b 65 64 20 2e 2e 2e 73 01 00 00 00 43 73 20 00 00 00 4c 69 73 74 69 6e 67 20	on.linked....s....Cs....Listing.
1480	43 20 69 6e 74 65 72 6e 61 6c 20 66 75 6e 63 74 69 6f 6e 73 20 2e 2e 2e 73 08 00 00 00 69 6e 74	C.internal.functions....s....int
14a0	65 72 6e 61 6c 73 21 00 00 00 4c 69 73 74 69 6e 67 20 53 51 4c 20 66 75 6e 63 74 69 6f 6e 73 20	ernals!...Listing.SQL.functions.
14c0	64 65 66 69 6e 65 64 20 2e 2e 2e 73 03 00 00 00 73 71 6c 73 21 00 00 00 4c 69 73 74 69 6e 67 20	defined....s....sqls!...Listing.
14e0	27 61 67 67 72 65 67 61 74 65 20 66 75 6e 63 74 69 6f 6e 73 27 20 2e 2e 2e 73 1e 00 00 00 4c 69	'aggregate.functions'....s....Li
1500	73 74 69 6e 67 20 27 6f 70 65 72 61 74 6f 72 20 63 6c 61 73 73 65 73 27 20 2e 2e 2e 28 0e 00 00	sting.'operator.classes'....(...
1520	00 73 0f 00 00 00 6c 69 73 74 5f 73 69 6d 70 6c 65 5f 69 6e 64 73 05 00 00 00 70 67 63 6e 78 73	.s....list_simple_inds....pgcnxs
1540	04 00 00 00 74 65 6d 70 73 07 00 00 00 64 69 73 70 6c 61 79 73 0a 00 00 00 6c 69 73 74 66 69 65	....temps....displays....listfie
1560	6c 64 73 73 09 00 00 00 67 65 74 72 65 73 75 6c 74 73 0d 00 00 00 6c 69 73 74 5f 61 6c 6c 5f 61	ldss....getresults....list_all_a
1580	74 74 72 73 13 00 00 00 6c 69 73 74 5f 75 73 65 72 5f 62 61 73 65 5f 74 79 70 65 73 18 00 00 00	ttrs....list_user_base_types....
15a0	6c 69 73 74 5f 6c 65 66 74 5f 75 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 73 19 00 00 00 6c 69 73	list_left_unary_operators....lis
15c0	74 5f 72 69 67 68 74 5f 75 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 73 14 00 00 00 6c 69 73 74 5f	t_right_unary_operators....list_
15e0	62 69 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 73 0e 00 00 00 6c 69 73 74 5f 6c 61 6e 67 5f 66 75	binary_operators....list_lang_fu
1600	6e 63 73 0d 00 00 00 6c 69 73 74 5f 61 67 67 5f 66 75 6e 63 73 0d 00 00 00 6c 69 73 74 5f 6f 70	ncs....list_agg_funcs....list_op
1620	5f 63 6c 61 73 73 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 04 00 00 00 74 65 6d 70 73 09	_class(....s....pgcnxs....temps.
1640	00 00 00 73 79 73 63 61 74 2e 70 79 73 04 00 00 00 64 65 6d 6f 6c 00 73 42 00 00 00 03 01 08 01	...syscat.pys....demol.sB.......
1660	0f 01 1c 01 08 01 0f 01 1c 01 08 01 0f 01 1c 01 08 01 0f 01 1c 01 08 01 0f 01 1c 01 08 01 0f 01	................................
1680	1c 01 08 01 12 01 1c 01 08 01 12 01 1c 01 08 01 12 01 1c 01 08 01 0f 01 1c 01 08 01 0f 01 4e 28	..............................N(
16a0	0d 00 00 00 73 05 00 00 00 70 67 65 78 74 73 01 00 00 00 2a 73 07 00 00 00 70 67 74 6f 6f 6c 73	....s....pgexts....*s....pgtools
16c0	73 0f 00 00 00 6c 69 73 74 5f 73 69 6d 70 6c 65 5f 69 6e 64 73 0d 00 00 00 6c 69 73 74 5f 61 6c	s....list_simple_inds....list_al
16e0	6c 5f 61 74 74 72 73 13 00 00 00 6c 69 73 74 5f 75 73 65 72 5f 62 61 73 65 5f 74 79 70 65 73 19	l_attrs....list_user_base_types.
1700	00 00 00 6c 69 73 74 5f 72 69 67 68 74 5f 75 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 73 18 00 00	...list_right_unary_operators...
1720	00 6c 69 73 74 5f 6c 65 66 74 5f 75 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 73 14 00 00 00 6c 69	.list_left_unary_operators....li
1740	73 74 5f 62 69 6e 61 72 79 5f 6f 70 65 72 61 74 6f 72 73 0e 00 00 00 6c 69 73 74 5f 6c 61 6e 67	st_binary_operators....list_lang
1760	5f 66 75 6e 63 73 0d 00 00 00 6c 69 73 74 5f 61 67 67 5f 66 75 6e 63 73 0d 00 00 00 6c 69 73 74	_funcs....list_agg_funcs....list
1780	5f 6f 70 5f 63 6c 61 73 73 73 04 00 00 00 64 65 6d 6f 28 00 00 00 00 73 09 00 00 00 73 79 73 63	_op_classs....demo(....s....sysc
17a0	61 74 2e 70 79 73 01 00 00 00 3f 05 00 73 36 00 00 00 0b 01 04 01 08 01 04 01 08 01 04 01 08 01	at.pys....?..s6.................
17c0	08 01 08 01 04 01 08 01 04 01 08 01 08 01 08 01 04 02 0a 01 0a 03 0c 0b 0c 0a 0c 09 0c 09 0c 09	................................
17e0	0c 0a 0c 08 0c 08 0c 08	........