blob: 91bdec9430faf2f8cbc63a2f71808bf3afd2fd1e (plain)

ofs	hex dump	ascii
0000	99 4e 0d 0a 0d 61 a1 34 63 00 00 00 00 01 00 00 00 73 97 00 00 00 7f 00 00 7f 06 00 64 00 00 47	.N...a.4c........s..........d..G
0020	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 64 03 00 47	H...d..GH...H...d..GH...H...d..G
0040	48 7f 0c 00 64 04 00 47 48 7f 0d 00 64 05 00 47 48 7f 0e 00 64 00 00 47 48 7f 10 00 6b 00 00 6c	H...d..GH...d..GH...d..GH...k..l
0060	01 00 01 7f 11 00 6b 02 00 6c 01 00 01 7f 14 00 64 06 00 84 00 00 5a 03 00 7f 63 00 64 07 00 84	......k..l......d.....Z...c.d...
0080	00 00 5a 04 00 7f 86 00 64 08 00 84 00 00 5a 05 00 7f c8 00 64 09 00 84 00 00 5a 06 00 7f d2 00	..Z.....d.....Z.....d.....Z.....
00a0	64 0a 00 84 00 00 5a 07 00 64 0b 00 53 28 0c 00 00 00 73 42 00 00 00 5f 5f 5f 5f 5f 5f 5f 5f 5f	d.....Z..d..S(....sB..._________
00c0	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	________________________________
00e0	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 3c 00 00 00 4d 4f	_________________________s<...MO
0100	44 55 4c 45 20 41 44 56 41 4e 43 45 44 2e 50 59 20 3a 20 41 44 56 41 4e 43 45 44 20 50 4f 53 54	DULE.ADVANCED.PY.:.ADVANCED.POST
0120	47 52 45 53 20 53 51 4c 20 43 4f 4d 4d 41 4e 44 53 20 54 55 54 4f 52 49 41 4c 73 3d 00 00 00 54	GRES.SQL.COMMANDS.TUTORIALs=...T
0140	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 69 6e 67	his.module.is.designed.for.being
0160	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 44 00 00	.imported.from.python.promptsD..
0180	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 69 6e 63	.In.order.to.run.the.samples.inc
01a0	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 6e 6e 65	luded.here,.first.create.a.conne
01c0	63 74 69 6f 6e 73 3a 00 00 00 75 73 69 6e 67 20 3a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20	ctions:...using.:...............
01e0	20 20 20 20 20 20 20 20 20 63 6e 78 20 3d 20 61 64 76 61 6e 63 65 64 2e 63 6f 6e 6e 65 63 74 28	.........cnx.=.advanced.connect(
0200	2e 2e 2e 29 73 31 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 74	...)s1...then.start.the.demo.wit
0220	68 3a 20 20 20 20 20 20 61 64 76 61 6e 63 65 64 2e 64 65 6d 6f 28 63 6e 78 29 63 01 00 02 00 03	h:......advanced.demo(cnx)c.....
0240	00 03 00 73 81 02 00 00 7f 14 00 7f 15 00 64 01 00 47 48 7f 16 00 64 02 00 47 48 7f 17 00 64 03	...s..........d..GH...d..GH...d.
0260	00 47 48 7f 18 00 64 04 00 47 48 7f 19 00 64 05 00 47 48 7f 1a 00 64 01 00 47 48 7f 1b 00 48 7f	.GH...d..GH...d..GH...d..GH...H.
0280	1c 00 64 06 00 47 48 7f 1d 00 64 07 00 47 48 7f 1e 00 48 7f 1f 00 64 08 00 47 48 7f 20 00 64 09	..d..GH...d..GH...H...d..GH...d.
02a0	00 47 48 7f 21 00 64 0a 00 47 48 7f 22 00 64 0b 00 47 48 7f 23 00 64 0c 00 47 48 7f 24 00 48 7f	.GH.!.d..GH.".d..GH.#.d..GH.$.H.
02c0	25 00 64 0d 00 47 48 7f 26 00 64 0e 00 47 48 7f 27 00 64 0f 00 47 48 7f 28 00 7c 00 00 69 01 00	%.d..GH.&.d..GH.'.d..GH.(.|..i..
02e0	64 10 00 83 01 00 01 7f 2c 00 7c 00 00 69 01 00 64 11 00 83 01 00 01 7f 2e 00 74 02 00 83 00 00	d.......,.|..i..d.........t.....
0300	01 7f 2f 00 48 7f 30 00 64 12 00 47 48 7f 31 00 48 7f 32 00 64 13 00 47 48 7f 33 00 64 14 00 47	../.H.0.d..GH.1.H.2.d..GH.3.d..G
0320	48 7f 34 00 64 15 00 47 48 7f 35 00 48 7f 36 00 64 16 00 47 48 7f 37 00 64 17 00 47 48 7f 38 00	H.4.d..GH.5.H.6.d..GH.7.d..GH.8.
0340	48 7f 39 00 7c 00 00 69 01 00 64 13 00 83 01 00 01 7f 3b 00 7c 00 00 69 01 00 64 14 00 83 01 00	H.9.|..i..d.......;.|..i..d.....
0360	01 7f 3d 00 7c 00 00 69 01 00 64 15 00 83 01 00 01 7f 3f 00 7c 00 00 69 01 00 64 16 00 83 01 00	..=.|..i..d.......?.|..i..d.....
0380	01 7f 41 00 7c 00 00 69 01 00 64 17 00 83 01 00 01 7f 43 00 48 7f 44 00 64 18 00 47 48 7f 45 00	..A.|..i..d.......C.H.D.d..GH.E.
03a0	7c 00 00 69 01 00 64 18 00 83 01 00 7d 01 00 7f 46 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01	|..i..d.....}...F.t..|..i.....|.
03c0	00 69 06 00 83 00 00 83 02 00 01 7f 47 00 64 19 00 47 48 7f 48 00 7c 00 00 69 01 00 64 19 00 83	.i..........G.d..GH.H.|..i..d...
03e0	01 00 7d 01 00 7f 49 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00	..}...I.t..|..i.....|..i........
0400	01 7f 4a 00 48 7f 4b 00 64 1a 00 47 48 7f 4c 00 64 1b 00 47 48 7f 4d 00 48 7f 4e 00 64 1c 00 47	..J.H.K.d..GH.L.d..GH.M.H.N.d..G
0420	48 7f 4f 00 64 1d 00 47 48 7f 50 00 64 1e 00 47 48 7f 51 00 7c 00 00 69 01 00 64 1f 00 83 01 00	H.O.d..GH.P.d..GH.Q.|..i..d.....
0440	7d 01 00 7f 54 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 7f	}...T.t..|..i.....|..i..........
0460	55 00 48 7f 56 00 64 20 00 47 48 7f 57 00 64 21 00 47 48 7f 58 00 64 22 00 47 48 7f 59 00 48 7f	U.H.V.d..GH.W.d!.GH.X.d".GH.Y.H.
0480	5a 00 64 23 00 47 48 7f 5b 00 64 24 00 47 48 7f 5c 00 64 25 00 47 48 7f 5d 00 7c 00 00 69 01 00	Z.d#.GH.[.d$.GH.\.d%.GH.].|..i..
04a0	64 26 00 83 01 00 7d 01 00 7f 60 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00	d&....}...`.t..|..i.....|..i....
04c0	00 83 02 00 01 64 00 00 53 28 27 00 00 00 4e 73 1d 00 00 00 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d	.....d..S('...Ns....------------
04e0	2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 73 0f 00 00 00 2d 2d 20 49 6e 68 65 72 69 74	-----------------s....--.Inherit
0500	61 6e 63 65 3a 73 38 00 00 00 2d 2d 09 61 20 74 61 62 6c 65 20 63 61 6e 20 69 6e 68 65 72 69 74	ance:s8...--.a.table.can.inherit
0520	20 66 72 6f 6d 20 7a 65 72 6f 20 6f 72 20 6d 6f 72 65 20 74 61 62 6c 65 73 2e 20 41 20 71 75 65	.from.zero.or.more.tables..A.que
0540	72 79 73 38 00 00 00 2d 2d 09 63 61 6e 20 72 65 66 65 72 65 6e 63 65 20 65 69 74 68 65 72 20 61	rys8...--.can.reference.either.a
0560	6c 6c 20 72 6f 77 73 20 6f 66 20 61 20 74 61 62 6c 65 20 6f 72 20 61 6c 6c 20 72 6f 77 73 20 73	ll.rows.of.a.table.or.all.rows.s
0580	2a 00 00 00 2d 2d 09 6f 66 20 61 20 74 61 62 6c 65 20 70 6c 75 73 20 61 6c 6c 20 6f 66 20 69 74	*...--.of.a.table.plus.all.of.it
05a0	73 20 64 65 73 63 65 6e 64 61 6e 74 73 2e 73 3e 00 00 00 2d 2d 20 46 6f 72 20 65 78 61 6d 70 6c	s.descendants.s>...--.For.exampl
05c0	65 2c 20 74 68 65 20 63 61 70 69 74 61 6c 73 20 74 61 62 6c 65 20 69 6e 68 65 72 69 74 73 20 66	e,.the.capitals.table.inherits.f
05e0	72 6f 6d 20 63 69 74 69 65 73 20 74 61 62 6c 65 2e 73 2e 00 00 00 2d 2d 20 28 49 74 20 69 6e 68	rom.cities.table.s....--.(It.inh
0600	65 72 69 74 73 20 20 61 6c 6c 20 64 61 74 61 20 66 69 65 6c 64 73 20 66 72 6f 6d 20 63 69 74 69	erits..all.data.fields.from.citi
0620	65 73 2e 29 73 15 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 69 74 69 65 73 20 28 73 0f	es.)s....CREATE.TABLE.cities.(s.
0640	00 00 00 20 20 20 20 6e 61 6d 65 09 09 74 65 78 74 2c 73 16 00 00 00 09 20 20 20 70 6f 70 75 6c	.......name..text,s........popul
0660	61 74 69 6f 6e 09 66 6c 6f 61 74 38 2c 73 10 00 00 00 20 20 20 20 61 6c 74 69 74 75 64 65 09 69	ation.float8,s........altitude.i
0680	6e 74 73 01 00 00 00 29 73 17 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 61 70 69 74 61	nts....)s....CREATE.TABLE.capita
06a0	6c 73 20 28 73 0f 00 00 00 20 20 20 20 73 74 61 74 65 09 63 68 61 72 32 73 13 00 00 00 29 20 49	ls.(s........state.char2s....).I
06c0	4e 48 45 52 49 54 53 20 28 63 69 74 69 65 73 29 73 3f 00 00 00 43 52 45 41 54 45 20 54 41 42 4c	NHERITS.(cities)s?...CREATE.TABL
06e0	45 20 63 69 74 69 65 73 20 28 6e 61 6d 65 09 09 74 65 78 74 2c 70 6f 70 75 6c 61 74 69 6f 6e 09	E.cities.(name..text,population.
0700	66 6c 6f 61 74 38 2c 61 6c 74 69 74 75 64 65 09 69 6e 74 29 73 36 00 00 00 43 52 45 41 54 45 20	float8,altitude.int)s6...CREATE.
0720	54 41 42 4c 45 20 63 61 70 69 74 61 6c 73 20 28 73 74 61 74 65 09 09 63 68 61 72 32 29 20 49 4e	TABLE.capitals.(state..char2).IN
0740	48 45 52 49 54 53 20 28 63 69 74 69 65 73 29 73 21 00 00 00 2d 2d 20 6e 6f 77 2c 20 6c 65 74 27	HERITS.(cities)s!...--.now,.let'
0760	73 20 70 6f 70 75 6c 61 74 65 20 74 68 65 20 74 61 62 6c 65 73 73 38 00 00 00 49 4e 53 45 52 54	s.populate.the.tabless8...INSERT
0780	20 49 4e 54 4f 20 63 69 74 69 65 73 20 56 41 4c 55 45 53 20 28 27 53 61 6e 20 46 72 61 6e 63 69	.INTO.cities.VALUES.('San.Franci
07a0	73 63 6f 27 2c 20 37 2e 32 34 45 2b 35 2c 20 36 33 29 73 37 00 00 00 49 4e 53 45 52 54 20 49 4e	sco',.7.24E+5,.63)s7...INSERT.IN
07c0	54 4f 20 63 69 74 69 65 73 20 56 41 4c 55 45 53 20 28 27 4c 61 73 20 56 65 67 61 73 27 2c 20 32	TO.cities.VALUES.('Las.Vegas',.2
07e0	2e 35 38 33 45 2b 35 2c 20 32 31 37 34 29 73 32 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 63	.583E+5,.2174)s2...INSERT.INTO.c
0800	69 74 69 65 73 20 56 41 4c 55 45 53 20 28 27 4d 61 72 69 70 6f 73 61 27 2c 20 31 32 30 30 2c 20	ities.VALUES.('Mariposa',.1200,.
0820	31 39 35 33 29 73 3e 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 63 61 70 69 74 61 6c 73 20 56	1953)s>...INSERT.INTO.capitals.V
0840	41 4c 55 45 53 20 28 27 53 61 63 72 61 6d 65 6e 74 6f 27 2c 20 33 2e 36 39 34 45 2b 35 2c 20 33	ALUES.('Sacramento',.3.694E+5,.3
0860	30 2c 20 27 43 41 27 29 73 3c 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 63 61 70 69 74 61 6c	0,.'CA')s<...INSERT.INTO.capital
0880	73 20 56 41 4c 55 45 53 20 28 27 4d 61 64 69 73 6f 6e 27 2c 20 31 2e 39 31 33 45 2b 35 2c 20 38	s.VALUES.('Madison',.1.913E+5,.8
08a0	34 35 2c 20 27 57 49 27 29 73 14 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 63 69 74 69	45,.'WI')s....SELECT.*.FROM.citi
08c0	65 73 73 16 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 63 61 70 69 74 61 6c 73 73 3b 00	ess....SELECT.*.FROM.capitalss;.
08e0	00 00 2d 2d 20 6c 69 6b 65 20 62 65 66 6f 72 65 2c 20 61 20 72 65 67 75 6c 61 72 20 71 75 65 72	..--.like.before,.a.regular.quer
0900	79 20 72 65 66 65 72 65 6e 63 65 73 20 72 6f 77 73 20 6f 66 20 74 68 65 20 62 61 73 65 73 0d 00	y.references.rows.of.the.bases..
0920	00 00 2d 2d 20 74 61 62 6c 65 20 6f 6e 6c 79 73 15 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 2c	..--.table.onlys....SELECT.name,
0940	20 61 6c 74 69 74 75 64 65 73 0b 00 00 00 46 52 4f 4d 20 63 69 74 69 65 73 73 15 00 00 00 57 48	.altitudes....FROM.citiess....WH
0960	45 52 45 20 61 6c 74 69 74 75 64 65 20 3e 20 35 30 30 3b 73 36 00 00 00 53 45 4c 45 43 54 20 6e	ERE.altitude.>.500;s6...SELECT.n
0980	61 6d 65 2c 20 61 6c 74 69 74 75 64 65 20 46 52 4f 4d 20 63 69 74 69 65 73 20 57 48 45 52 45 20	ame,.altitude.FROM.cities.WHERE.
09a0	61 6c 74 69 74 75 64 65 20 3e 20 35 30 30 73 39 00 00 00 2d 2d 20 6f 6e 20 74 68 65 20 6f 74 68	altitude.>.500s9...--.on.the.oth
09c0	65 72 20 68 61 6e 64 2c 20 79 6f 75 20 63 61 6e 20 66 69 6e 64 20 61 6c 6c 20 63 69 74 69 65 73	er.hand,.you.can.find.all.cities
09e0	2c 20 69 6e 63 6c 75 64 69 6e 67 20 73 38 00 00 00 2d 2d 20 63 61 70 69 74 61 6c 73 2c 20 74 68	,.including.s8...--.capitals,.th
0a00	61 74 20 61 72 65 20 6c 6f 63 61 74 65 64 20 61 74 20 61 6e 20 61 6c 74 69 74 75 64 65 20 6f 66	at.are.located.at.an.altitude.of
0a20	20 35 30 30 20 27 66 74 20 73 10 00 00 00 2d 2d 20 6f 72 20 68 69 67 68 65 72 20 62 79 3a 73 19	.500.'ft.s....--.or.higher.by:s.
0a40	00 00 00 53 45 4c 45 43 54 20 63 2e 6e 61 6d 65 2c 20 63 2e 61 6c 74 69 74 75 64 65 73 0e 00 00	...SELECT.c.name,.c.altitudes...
0a60	00 46 52 4f 4d 20 63 69 74 69 65 73 2a 20 63 73 16 00 00 00 57 48 45 52 45 20 63 2e 61 6c 74 69	.FROM.cities*.cs....WHERE.c.alti
0a80	74 75 64 65 20 3e 20 35 30 30 73 3f 00 00 00 53 45 4c 45 43 54 20 63 2e 6e 61 6d 65 2c 20 63 2e	tude.>.500s?...SELECT.c.name,.c.
0aa0	61 6c 74 69 74 75 64 65 20 46 52 4f 4d 20 63 69 74 69 65 73 2a 20 63 20 57 48 45 52 45 20 63 2e	altitude.FROM.cities*.c.WHERE.c.
0ac0	61 6c 74 69 74 75 64 65 20 3e 20 35 30 30 28 07 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00	altitude.>.500(....s....pgcnxs..
0ae0	00 00 71 75 65 72 79 73 08 00 00 00 77 61 69 74 5f 6b 65 79 73 01 00 00 00 71 73 07 00 00 00 64	..querys....wait_keys....qs....d
0b00	69 73 70 6c 61 79 73 0a 00 00 00 6c 69 73 74 66 69 65 6c 64 73 73 09 00 00 00 67 65 74 72 65 73	isplays....listfieldss....getres
0b20	75 6c 74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 01 00 00 00 71 73 0b 00 00 00 61 64 76	ult(....s....pgcnxs....qs....adv
0b40	61 6e 63 65 64 2e 70 79 73 0c 00 00 00 69 6e 68 65 72 69 74 5f 64 65 6d 6f 14 00 73 7e 00 00 00	anced.pys....inherit_demo..s~...
0b60	03 01 08 01 08 01 08 01 08 01 08 01 08 01 04 01 08 01 08 01 04 01 08 01 08 01 08 01 08 01 08 01	................................
0b80	04 01 08 01 08 01 08 01 10 04 10 02 0a 01 04 01 08 01 04 01 08 01 08 01 08 01 04 01 08 01 08 01	................................
0ba0	04 01 10 02 10 02 10 02 10 02 10 02 04 01 08 01 12 01 1c 01 08 01 12 01 1c 01 04 01 08 01 08 01	................................
0bc0	04 01 08 01 08 01 08 01 12 03 1c 01 04 01 08 01 08 01 08 01 04 01 08 01 08 01 08 01 12 03 63 01	..............................c.
0be0	00 02 00 03 00 03 00 73 15 01 00 00 7f 63 00 7f 64 00 64 01 00 47 48 7f 65 00 64 02 00 47 48 7f	.......s.....c..d.d..GH.e.d..GH.
0c00	66 00 64 03 00 47 48 7f 67 00 64 01 00 47 48 7f 68 00 48 7f 69 00 64 04 00 47 48 7f 6a 00 64 05	f.d..GH.g.d..GH.h.H.i.d..GH.j.d.
0c20	00 47 48 7f 6b 00 48 7f 6c 00 64 06 00 47 48 7f 6d 00 64 07 00 47 48 7f 6e 00 64 08 00 47 48 7f	.GH.k.H.l.d..GH.m.d..GH.n.d..GH.
0c40	6f 00 7c 00 00 69 01 00 64 09 00 83 01 00 01 7f 72 00 74 02 00 83 00 00 01 7f 73 00 48 7f 74 00	o.|..i..d.......r.t.......s.H.t.
0c60	64 0a 00 47 48 7f 75 00 48 7f 76 00 64 0b 00 47 48 7f 77 00 7c 00 00 69 01 00 64 0c 00 83 01 00	d..GH.u.H.v.d..GH.w.|..i..d.....
0c80	7d 01 00 7f 78 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 7f	}...x.t..|..i.....|..i..........
0ca0	79 00 48 7f 7a 00 64 0d 00 47 48 7f 7b 00 64 0e 00 47 48 7f 7c 00 48 7f 7d 00 64 0f 00 47 48 7f	y.H.z.d..GH.{.d..GH.|.H.}.d..GH.
0cc0	7e 00 64 10 00 47 48 7f 7f 00 64 08 00 47 48 7f 80 00 7c 00 00 69 01 00 64 11 00 83 01 00 7d 01	~.d..GH...d..GH...|..i..d.....}.
0ce0	00 7f 83 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 64 00 00	....t..|..i.....|..i.........d..
0d00	53 28 12 00 00 00 4e 73 1d 00 00 00 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d	S(....Ns....--------------------
0d20	2d 2d 2d 2d 2d 2d 2d 2d 2d 73 0f 00 00 00 2d 2d 20 54 69 6d 65 20 54 72 61 76 65 6c 3a 73 36 00	---------s....--.Time.Travel:s6.
0d40	00 00 2d 2d 09 74 68 69 73 20 66 65 61 74 75 72 65 20 61 6c 6c 6f 77 73 20 79 6f 75 20 74 6f 20	..--.this.feature.allows.you.to.
0d60	72 75 6e 20 68 69 73 74 6f 72 69 63 61 6c 20 71 75 65 72 69 65 73 2e 20 73 3e 00 00 00 2d 2d 20	run.historical.queries..s>...--.
0d80	66 69 72 73 74 2c 20 6c 65 74 27 73 20 6d 61 6b 65 20 73 6f 6d 65 20 63 68 61 6e 67 65 73 20 74	first,.let's.make.some.changes.t
0da0	6f 20 74 68 65 20 63 69 74 69 65 73 20 74 61 62 6c 65 20 28 73 75 70 70 6f 73 65 73 2d 00 00 00	o.the.cities.table.(supposes-...
0dc0	2d 2d 20 4d 61 72 69 70 6f 73 61 27 73 20 70 6f 70 75 6c 61 74 69 6f 6e 20 67 72 6f 77 73 20 31	--.Mariposa's.population.grows.1
0de0	30 25 20 74 68 69 73 20 79 65 61 72 29 73 0d 00 00 00 55 50 44 41 54 45 20 63 69 74 69 65 73 73	0%.this.year)s....UPDATE.citiess
0e00	21 00 00 00 53 45 54 20 70 6f 70 75 6c 61 74 69 6f 6e 20 3d 20 70 6f 70 75 6c 61 74 69 6f 6e 20	!...SET.population.=.population.
0e20	2a 20 31 2e 31 73 18 00 00 00 57 48 45 52 45 20 6e 61 6d 65 20 3d 20 27 4d 61 72 69 70 6f 73 61	*.1.1s....WHERE.name.=.'Mariposa
0e40	27 3b 73 46 00 00 00 55 50 44 41 54 45 20 63 69 74 69 65 73 20 53 45 54 20 70 6f 70 75 6c 61 74	';sF...UPDATE.cities.SET.populat
0e60	69 6f 6e 20 3d 20 70 6f 70 75 6c 61 74 69 6f 6e 20 2a 20 31 2e 31 57 48 45 52 45 20 6e 61 6d 65	ion.=.population.*.1.1WHERE.name
0e80	20 3d 20 27 4d 61 72 69 70 6f 73 61 27 73 30 00 00 00 2d 2d 20 74 68 65 20 64 65 66 61 75 6c 74	.=.'Mariposa's0...--.the.default
0ea0	20 74 69 6d 65 20 69 73 20 74 68 65 20 63 75 72 72 65 6e 74 20 74 69 6d 65 20 28 27 6e 6f 77 27	.time.is.the.current.time.('now'
0ec0	29 3a 73 2d 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 63 69 74 69 65 73 20 57 48 45 52	):s-...SELECT.*.FROM.cities.WHER
0ee0	45 20 6e 61 6d 65 20 3d 20 27 4d 61 72 69 70 6f 73 61 27 3b 73 2c 00 00 00 53 45 4c 45 43 54 20	E.name.=.'Mariposa';s,...SELECT.
0f00	2a 20 46 52 4f 4d 20 63 69 74 69 65 73 20 57 48 45 52 45 20 6e 61 6d 65 20 3d 20 27 4d 61 72 69	*.FROM.cities.WHERE.name.=.'Mari
0f20	70 6f 73 61 27 73 3d 00 00 00 2d 2d 20 77 65 20 63 61 6e 20 61 6c 73 6f 20 72 65 74 72 69 65 76	posa's=...--.we.can.also.retriev
0f40	65 20 74 68 65 20 70 6f 70 75 6c 61 74 69 6f 6e 20 6f 66 20 4d 61 72 69 70 6f 73 61 20 65 76 65	e.the.population.of.Mariposa.eve
0f60	72 20 68 61 73 2e 20 73 3d 00 00 00 2d 2d 20 28 27 65 70 6f 63 68 27 20 69 73 20 74 68 65 20 65	r.has..s=...--.('epoch'.is.the.e
0f80	61 72 6c 69 65 73 74 20 74 69 6d 65 20 72 65 70 72 65 73 65 6e 74 61 62 6c 65 20 62 79 20 74 68	arliest.time.representable.by.th
0fa0	65 20 73 79 73 74 65 6d 29 73 17 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 2c 20 70 6f 70 75 6c	e.system)s....SELECT.name,.popul
0fc0	61 74 69 6f 6e 73 3f 00 00 00 46 52 4f 4d 20 63 69 74 69 65 73 5b 27 65 70 6f 63 68 27 2c 20 27	ations?...FROM.cities['epoch',.'
0fe0	6e 6f 77 27 5d 20 20 2d 2d 20 63 61 6e 20 62 65 20 61 62 62 72 65 76 69 61 74 65 64 20 74 6f 20	now']..--.can.be.abbreviated.to.
1000	63 69 74 69 65 73 5b 2c 5d 73 4b 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 2c 20 70 6f 70 75 6c	cities[,]sK...SELECT.name,.popul
1020	61 74 69 6f 6e 20 46 52 4f 4d 20 63 69 74 69 65 73 5b 27 65 70 6f 63 68 27 2c 20 27 6e 6f 77 27	ation.FROM.cities['epoch',.'now'
1040	5d 20 57 48 45 52 45 20 6e 61 6d 65 20 3d 20 27 4d 61 72 69 70 6f 73 61 27 28 07 00 00 00 73 05	].WHERE.name.=.'Mariposa'(....s.
1060	00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79 73 08 00 00 00 77 61 69 74 5f 6b 65 79 73	...pgcnxs....querys....wait_keys
1080	01 00 00 00 71 73 07 00 00 00 64 69 73 70 6c 61 79 73 0a 00 00 00 6c 69 73 74 66 69 65 6c 64 73	....qs....displays....listfields
10a0	73 09 00 00 00 67 65 74 72 65 73 75 6c 74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 01 00	s....getresult(....s....pgcnxs..
10c0	00 00 71 73 0b 00 00 00 61 64 76 61 6e 63 65 64 2e 70 79 73 0b 00 00 00 74 69 6d 65 5f 74 72 61	..qs....advanced.pys....time_tra
10e0	76 65 6c 63 00 73 38 00 00 00 03 01 08 01 08 01 08 01 08 01 04 01 08 01 08 01 04 01 08 01 08 01	velc.s8.........................
1100	08 01 10 03 0a 01 04 01 08 01 04 01 08 01 12 01 1c 01 04 01 08 01 08 01 04 01 08 01 08 01 08 01	................................
1120	12 03 63 01 00 02 00 03 00 03 00 73 f9 01 00 00 7f 86 00 7f 87 00 64 01 00 47 48 7f 88 00 64 02	..c........s..........d..GH...d.
1140	00 47 48 7f 89 00 64 03 00 47 48 7f 8a 00 64 04 00 47 48 7f 8b 00 64 01 00 47 48 7f 8c 00 48 7f	.GH...d..GH...d..GH...d..GH...H.
1160	8d 00 64 05 00 47 48 7f 8e 00 64 06 00 47 48 7f 8f 00 64 07 00 47 48 7f 90 00 64 08 00 47 48 7f	..d..GH...d..GH...d..GH...d..GH.
1180	91 00 64 09 00 47 48 7f 92 00 7c 00 00 69 01 00 64 0a 00 83 01 00 01 7f 96 00 74 02 00 83 00 00	..d..GH...|..i..d.........t.....
11a0	01 7f 97 00 48 7f 98 00 64 0b 00 47 48 7f 99 00 64 0c 00 47 48 7f 9a 00 48 7f 9b 00 64 0d 00 47	....H...d..GH...d..GH...H...d..G
11c0	48 7f 9c 00 64 0e 00 47 48 7f 9d 00 64 0f 00 47 48 7f 9e 00 64 10 00 47 48 7f 9f 00 48 7f a0 00	H...d..GH...d..GH...d..GH...H...
11e0	64 0d 00 47 48 7f a1 00 64 11 00 47 48 7f a2 00 64 12 00 47 48 7f a3 00 64 13 00 47 48 7f a4 00	d..GH...d..GH...d..GH...d..GH...
1200	48 7f a5 00 7c 00 00 69 01 00 64 14 00 83 01 00 01 7f a8 00 7c 00 00 69 01 00 64 15 00 83 01 00	H...|..i..d.........|..i..d.....
1220	01 7f ab 00 74 02 00 83 00 00 01 7f ac 00 48 7f ad 00 64 01 00 47 48 7f ae 00 64 16 00 47 48 7f	....t.........H...d..GH...d..GH.
1240	af 00 64 01 00 47 48 7f b0 00 48 7f b1 00 64 17 00 47 48 7f b2 00 64 18 00 47 48 7f b3 00 48 7f	..d..GH...H...d..GH...d..GH...H.
1260	b4 00 7c 00 00 69 01 00 64 19 00 83 01 00 7d 01 00 7f b6 00 74 04 00 7c 01 00 69 05 00 83 00 00	..|..i..d.....}.....t..|..i.....
1280	7c 01 00 69 06 00 83 00 00 83 02 00 01 7f b7 00 48 7f b8 00 64 1a 00 47 48 7f b9 00 48 7f ba 00	|..i............H...d..GH...H...
12a0	64 1b 00 47 48 7f bb 00 48 7f bc 00 7c 00 00 69 01 00 64 1b 00 83 01 00 7d 01 00 7f bd 00 74 04	d..GH...H...|..i..d.....}.....t.
12c0	00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00 00 83 02 00 01 7f be 00 48 7f bf 00 64 1c	.|..i.....|..i............H...d.
12e0	00 47 48 7f c0 00 48 7f c1 00 64 1d 00 47 48 7f c2 00 64 1e 00 47 48 7f c3 00 7c 00 00 69 01 00	.GH...H...d..GH...d..GH...|..i..
1300	64 1f 00 83 01 00 7d 01 00 7f c5 00 74 04 00 7c 01 00 69 05 00 83 00 00 7c 01 00 69 06 00 83 00	d.....}.....t..|..i.....|..i....
1320	00 83 02 00 01 64 00 00 53 28 20 00 00 00 4e 73 16 00 00 00 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d	.....d..S(....Ns....------------
1340	2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 73 0a 00 00 00 2d 2d 20 41 72 72 61 79 73 3a 73 3f 00 00 00 2d 2d	----------s....--.Arrays:s?...--
1360	20 20 20 20 20 20 61 74 74 72 69 62 75 74 65 73 20 63 61 6e 20 62 65 20 61 72 72 61 79 73 20 6f	......attributes.can.be.arrays.o
1380	66 20 62 61 73 65 20 74 79 70 65 73 20 6f 72 20 75 73 65 72 2d 64 65 66 69 6e 65 64 20 73 0d 00	f.base.types.or.user-defined.s..
13a0	00 00 2d 2d 20 20 20 20 20 20 74 79 70 65 73 73 16 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45	..--......typess....CREATE.TABLE
13c0	20 73 61 6c 5f 65 6d 70 20 28 73 10 00 00 00 20 20 20 20 6e 61 6d 65 09 09 09 74 65 78 74 2c 73	.sal_emp.(s........name...text,s
13e0	1a 00 00 00 20 20 20 20 70 61 79 5f 62 79 5f 71 75 61 72 74 65 72 09 69 6e 74 34 5b 5d 2c 73 18	........pay_by_quarter.int4[],s.
1400	00 00 00 20 20 20 20 73 63 68 65 64 75 6c 65 09 09 63 68 61 72 31 36 5b 5d 5b 5d 73 01 00 00 00	.......schedule..char16[][]s....
1420	29 73 4a 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 73 61 6c 5f 65 6d 70 20 28 6e 61 6d 65	)sJ...CREATE.TABLE.sal_emp.(name
1440	09 74 65 78 74 2c 70 61 79 5f 62 79 5f 71 75 61 72 74 65 72 09 69 6e 74 34 5b 5d 2c 73 63 68 65	.text,pay_by_quarter.int4[],sche
1460	64 75 6c 65 09 63 68 61 72 31 36 5b 5d 5b 5d 29 73 2c 00 00 00 2d 2d 20 69 6e 73 65 72 74 20 69	dule.char16[][])s,...--.insert.i
1480	6e 73 74 61 6e 63 65 73 20 77 69 74 68 20 61 72 72 61 79 20 61 74 74 72 69 62 75 74 65 73 2e 20	nstances.with.array.attributes..
14a0	20 73 19 00 00 00 20 20 20 4e 6f 74 65 20 74 68 65 20 75 73 65 20 6f 66 20 62 72 61 63 65 73 73	.s.......Note.the.use.of.bracess
14c0	1c 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 73 61 6c 5f 65 6d 70 20 56 41 4c 55 45 53 20 28	....INSERT.INTO.sal_emp.VALUES.(
14e0	73 0b 00 00 00 20 20 20 20 27 42 69 6c 6c 27 2c 73 20 00 00 00 20 20 20 20 27 7b 31 30 30 30 30	s........'Bill',s........'{10000
1500	2c 31 30 30 30 30 2c 31 30 30 30 30 2c 31 30 30 30 30 7d 27 2c 73 21 00 00 00 20 20 20 20 27 7b	,10000,10000,10000}',s!.......'{
1520	7b 22 6d 65 65 74 69 6e 67 22 2c 20 22 6c 75 6e 63 68 22 7d 2c 20 7b 7d 7d 27 29 73 0c 00 00 00	{"meeting",."lunch"},.{}}')s....
1540	20 20 20 20 27 43 61 72 6f 6c 27 2c 73 20 00 00 00 20 20 20 20 27 7b 32 30 30 30 30 2c 32 35 30	....'Carol',s........'{20000,250
1560	30 30 2c 32 35 30 30 30 2c 32 35 30 30 30 7d 27 2c 73 29 00 00 00 20 20 20 20 27 7b 7b 22 74 61	00,25000,25000}',s).......'{{"ta
1580	6c 6b 22 2c 20 22 63 6f 6e 73 75 6c 74 22 7d 2c 20 7b 22 6d 65 65 74 69 6e 67 22 7d 7d 27 29 73	lk",."consult"},.{"meeting"}}')s
15a0	5d 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 73 61 6c 5f 65 6d 70 20 56 41 4c 55 45 53 20 28	]...INSERT.INTO.sal_emp.VALUES.(
15c0	27 42 69 6c 6c 27 2c 20 27 7b 31 30 30 30 30 2c 31 30 30 30 30 2c 31 30 30 30 30 2c 31 30 30 30	'Bill',.'{10000,10000,10000,1000
15e0	30 7d 27 2c 27 7b 7b 22 6d 65 65 74 69 6e 67 22 2c 20 22 6c 75 6e 63 68 22 7d 2c 20 7b 7d 7d 27	0}','{{"meeting",."lunch"},.{}}'
1600	29 73 66 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 73 61 6c 5f 65 6d 70 20 56 41 4c 55 45 53	)sf...INSERT.INTO.sal_emp.VALUES
1620	20 28 27 43 61 72 6f 6c 27 2c 20 27 7b 32 30 30 30 30 2c 32 35 30 30 30 2c 32 35 30 30 30 2c 32	.('Carol',.'{20000,25000,25000,2
1640	35 30 30 30 7d 27 2c 27 7b 7b 22 74 61 6c 6b 22 2c 20 22 63 6f 6e 73 75 6c 74 22 7d 2c 20 7b 22	5000}','{{"talk",."consult"},.{"
1660	6d 65 65 74 69 6e 67 22 7d 7d 27 29 73 1e 00 00 00 2d 2d 20 71 75 65 72 69 65 73 20 6f 6e 20 61	meeting"}}')s....--.queries.on.a
1680	72 72 61 79 20 61 74 74 72 69 62 75 74 65 73 73 1e 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 20	rray.attributess....SELECT.name.
16a0	46 52 4f 4d 20 73 61 6c 5f 65 6d 70 20 57 48 45 52 45 73 38 00 00 00 20 20 73 61 6c 5f 65 6d 70	FROM.sal_emp.WHEREs8.....sal_emp
16c0	2e 70 61 79 5f 62 79 5f 71 75 61 72 74 65 72 5b 31 5d 20 3c 3e 20 73 61 6c 5f 65 6d 70 2e 70 61	.pay_by_quarter[1].<>.sal_emp.pa
16e0	79 5f 62 79 5f 71 75 61 72 74 65 72 5b 32 5d 73 55 00 00 00 53 45 4c 45 43 54 20 6e 61 6d 65 20	y_by_quarter[2]sU...SELECT.name.
1700	46 52 4f 4d 20 73 61 6c 5f 65 6d 70 20 57 48 45 52 45 20 73 61 6c 5f 65 6d 70 2e 70 61 79 5f 62	FROM.sal_emp.WHERE.sal_emp.pay_b
1720	79 5f 71 75 61 72 74 65 72 5b 31 5d 20 3c 3e 20 73 61 6c 5f 65 6d 70 2e 70 61 79 5f 62 79 5f 71	y_quarter[1].<>.sal_emp.pay_by_q
1740	75 61 72 74 65 72 5b 32 5d 73 2e 00 00 00 2d 2d 20 72 65 74 72 69 65 76 65 20 74 68 69 72 64 20	uarter[2]s....--.retrieve.third.
1760	71 75 61 72 74 65 72 20 70 61 79 20 6f 66 20 61 6c 6c 20 65 6d 70 6c 6f 79 65 65 73 73 2d 00 00	quarter.pay.of.all.employeess-..
1780	00 53 45 4c 45 43 54 20 73 61 6c 5f 65 6d 70 2e 70 61 79 5f 62 79 5f 71 75 61 72 74 65 72 5b 33	.SELECT.sal_emp.pay_by_quarter[3
17a0	5d 20 46 52 4f 4d 20 73 61 6c 5f 65 6d 70 73 13 00 00 00 2d 2d 20 73 65 6c 65 63 74 20 73 75 62	].FROM.sal_emps....--.select.sub
17c0	61 72 72 61 79 73 73 35 00 00 00 53 45 4c 45 43 54 20 73 61 6c 5f 65 6d 70 2e 73 63 68 65 64 75	arrayss5...SELECT.sal_emp.schedu
17e0	6c 65 5b 31 3a 32 5d 5b 31 3a 31 5d 20 46 52 4f 4d 20 73 61 6c 5f 65 6d 70 20 57 48 45 52 45 09	le[1:2][1:1].FROM.sal_emp.WHERE.
1800	73 1a 00 00 00 20 20 20 20 20 73 61 6c 5f 65 6d 70 2e 6e 61 6d 65 20 3d 20 27 42 69 6c 6c 27 73	s.........sal_emp.name.=.'Bill's
1820	4a 00 00 00 53 45 4c 45 43 54 20 73 61 6c 5f 65 6d 70 2e 73 63 68 65 64 75 6c 65 5b 31 3a 32 5d	J...SELECT.sal_emp.schedule[1:2]
1840	5b 31 3a 31 5d 20 46 52 4f 4d 20 73 61 6c 5f 65 6d 70 20 57 48 45 52 45 20 73 61 6c 5f 65 6d 70	[1:1].FROM.sal_emp.WHERE.sal_emp
1860	2e 6e 61 6d 65 20 3d 20 27 42 69 6c 6c 27 28 07 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00	.name.=.'Bill'(....s....pgcnxs..
1880	00 00 71 75 65 72 79 73 08 00 00 00 77 61 69 74 5f 6b 65 79 73 01 00 00 00 71 73 07 00 00 00 64	..querys....wait_keys....qs....d
18a0	69 73 70 6c 61 79 73 0a 00 00 00 6c 69 73 74 66 69 65 6c 64 73 73 09 00 00 00 67 65 74 72 65 73	isplays....listfieldss....getres
18c0	75 6c 74 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 01 00 00 00 71 73 0b 00 00 00 61 64 76	ult(....s....pgcnxs....qs....adv
18e0	61 6e 63 65 64 2e 70 79 73 0a 00 00 00 61 72 72 61 79 5f 64 65 6d 6f 86 00 73 6c 00 00 00 03 01	anced.pys....array_demo..sl.....
1900	08 01 08 01 08 01 08 01 08 01 04 01 08 01 08 01 08 01 08 01 08 01 10 04 0a 01 04 01 08 01 08 01	................................
1920	04 01 08 01 08 01 08 01 08 01 04 01 08 01 08 01 08 01 08 01 04 01 10 03 10 03 0a 01 04 01 08 01	................................
1940	08 01 08 01 04 01 08 01 08 01 04 01 12 02 1c 01 04 01 08 01 04 01 08 01 04 01 12 01 1c 01 04 01	................................
1960	08 01 04 01 08 01 08 01 12 02 63 01 00 01 00 02 00 03 00 73 57 00 00 00 7f c8 00 7f c9 00 64 01	..........c........sW.........d.
1980	00 47 48 7f ca 00 64 02 00 47 48 7f cb 00 64 03 00 47 48 7f cc 00 64 04 00 47 48 7f cd 00 7c 00	.GH...d..GH...d..GH...d..GH...|.
19a0	00 69 01 00 64 02 00 83 01 00 01 7f ce 00 7c 00 00 69 01 00 64 03 00 83 01 00 01 7f cf 00 7c 00	.i..d.........|..i..d.........|.
19c0	00 69 01 00 64 05 00 83 01 00 01 64 00 00 53 28 06 00 00 00 4e 73 30 00 00 00 2d 2d 20 63 6c 65	.i..d......d..S(....Ns0...--.cle
19e0	61 6e 20 75 70 20 28 79 6f 75 20 6d 75 73 74 20 72 65 6d 6f 76 65 20 74 68 65 20 63 68 69 6c 64	an.up.(you.must.remove.the.child
1a00	72 65 6e 20 66 69 72 73 74 29 73 12 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 73 61 6c 5f 65 6d	ren.first)s....DROP.TABLE.sal_em
1a20	70 73 13 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 63 61 70 69 74 61 6c 73 73 12 00 00 00 44 52	ps....DROP.TABLE.capitalss....DR
1a40	4f 50 20 54 41 42 4c 45 20 63 69 74 69 65 73 3b 73 11 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20	OP.TABLE.cities;s....DROP.TABLE.
1a60	63 69 74 69 65 73 28 02 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 05 00 00 00 71 75 65 72 79 28	cities(....s....pgcnxs....query(
1a80	01 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 0b 00 00 00 61 64 76 61 6e 63 65 64 2e 70 79 73 0c	....s....pgcnxs....advanced.pys.
1aa0	00 00 00 64 65 6d 6f 5f 63 6c 65 61 6e 75 70 c8 00 73 0e 00 00 00 03 01 08 01 08 01 08 01 08 01	...demo_cleanup..s..............
1ac0	10 01 10 01 63 01 00 01 00 02 00 03 00 73 3b 00 00 00 7f d2 00 7f d3 00 74 00 00 7c 00 00 83 01	....c........s;.........t..|....
1ae0	00 01 7f d4 00 74 02 00 7c 00 00 83 01 00 01 7f d5 00 74 03 00 7c 00 00 83 01 00 01 7f d6 00 74	.....t..|.........t..|.........t
1b00	04 00 7c 00 00 83 01 00 01 64 00 00 53 28 01 00 00 00 4e 28 05 00 00 00 73 0c 00 00 00 69 6e 68	..|......d..S(....N(....s....inh
1b20	65 72 69 74 5f 64 65 6d 6f 73 05 00 00 00 70 67 63 6e 78 73 0b 00 00 00 74 69 6d 65 5f 74 72 61	erit_demos....pgcnxs....time_tra
1b40	76 65 6c 73 0a 00 00 00 61 72 72 61 79 5f 64 65 6d 6f 73 0c 00 00 00 64 65 6d 6f 5f 63 6c 65 61	vels....array_demos....demo_clea
1b60	6e 75 70 28 01 00 00 00 73 05 00 00 00 70 67 63 6e 78 73 0b 00 00 00 61 64 76 61 6e 63 65 64 2e	nup(....s....pgcnxs....advanced.
1b80	70 79 73 04 00 00 00 64 65 6d 6f d2 00 73 08 00 00 00 03 01 0d 01 0d 01 0d 01 4e 28 08 00 00 00	pys....demo..s............N(....
1ba0	73 07 00 00 00 70 67 74 6f 6f 6c 73 73 01 00 00 00 2a 73 05 00 00 00 70 67 65 78 74 73 0c 00 00	s....pgtoolss....*s....pgexts...
1bc0	00 69 6e 68 65 72 69 74 5f 64 65 6d 6f 73 0b 00 00 00 74 69 6d 65 5f 74 72 61 76 65 6c 73 0a 00	.inherit_demos....time_travels..
1be0	00 00 61 72 72 61 79 5f 64 65 6d 6f 73 0c 00 00 00 64 65 6d 6f 5f 63 6c 65 61 6e 75 70 73 04 00	..array_demos....demo_cleanups..
1c00	00 00 64 65 6d 6f 28 00 00 00 00 73 0b 00 00 00 61 64 76 61 6e 63 65 64 2e 70 79 73 01 00 00 00	..demo(....s....advanced.pys....
1c20	3f 06 00 73 1e 00 00 00 0b 01 08 01 04 01 08 01 04 01 08 01 08 01 08 01 08 02 0a 01 0a 03 0c 4f	?..s...........................O
1c40	0c 23 0c 42 0c 0a	.#.B..