$ echo " select rank , userid , username , xp , userlevel , writeups , usersince , lasthere from saints_in_our_book() where rank <= 50 ; " | psql -qX rank | userid | username | xp | userlevel | writeups | usersince | lasthere ------+--------+----------------------+---------+-----------------+----------+---------------------+---------------- 1 | 979 | vroom | 1007449 | Pope (28) | 607 | 1999-11-12 05:53:00 | 37 weeks ago 2 | 171588 | BrowserUk | 156800 | Pope (28) | 22020 | 2002-06-04 18:12:00 | 13 minutes ago 3 | 381608 | ikegami | 126952 | Pope (28) | 19570 | 2004-08-10 14:55:00 | 15 hours ago 4 | 5348 | Corion | 117813 | Pope (28) | 9369 | 2000-03-14 13:56:00 | 4 hours ago 5 | 9073 | merlyn | 71106 | Sage (25) | 6322 | 2000-04-25 22:41:00 | 5 weeks ago 6 | 461912 | GrandFather | 70930 | Sage (25) | 6450 | 2005-05-31 03:02:00 | 8 seconds ago 7 | 22609 | tye | 69775 | Cardinal (24) | 7769 | 2000-07-14 22:45:00 | 13 hours ago 8 | 616540 | moritz | 65723 | Cardinal (24) | 6415 | 2007-05-21 12:33:00 | 23 hours ago 9 | 17000 | Ovid | 60423 | Cardinal (24) | 2990 | 2000-06-08 04:57:00 | 1 week ago 10 | 85580 | dragonchild | 58436 | Archbishop (23) | 5988 | 2001-06-04 23:41:00 | 4 days ago 11 | 1382 | chromatic | 58205 | Archbishop (23) | 5941 | 1999-12-24 11:10:00 | 5 weeks ago 12 | 26179 | tilly | 57174 | Archbishop (23) | 5646 | 2000-08-04 16:59:00 | 1 year ago 13 | 131741 | zentara | 56223 | Archbishop (23) | 7239 | 2001-12-14 00:14:00 | 40 weeks ago 14 | 281137 | davido | 55541 | Archbishop (23) | 4698 | 2003-08-05 19:52:00 | 16 hours ago 15 | 82147 | Zaxo | 54786 | Archbishop (23) | 3416 | 2001-05-22 05:34:00 | 6 years ago 16 | 352046 | ww | 45944 | Bishop (22) | 3539 | 2004-05-10 13:43:00 | 13 hours ago 17 | 290905 | Old_Gray_Bear | 45468 | Bishop (22) | 587 | 2003-09-12 02:59:00 | 11 hours ago 18 | 29008 | grinder | 43661 | Bishop (22) | 1570 | 2000-08-22 17:56:00 | 6 years ago 19 | 198160 | CountZero | 42943 | Bishop (22) | 4284 | 2002-09-16 05:38:00 | 3 hours ago 20 | 324763 | marto | 42094 | Bishop (22) | 4470 | 2004-01-28 20:01:00 | 24 hours ago 21 | 622051 | toolic | 41484 | Bishop (22) | 3483 | 2007-06-19 16:21:00 | 10 hours ago 22 | 169744 | Abigail-II | 40866 | Bishop (22) | 4089 | 2002-05-28 11:53:00 | 6 years ago 23 | 18800 | jeffa | 40192 | Bishop (22) | 2764 | 2000-06-19 19:14:00 | 16 hours ago 24 | 22308 | dws | 38846 | Chancellor (21) | 2536 | 2000-07-13 05:09:00 | 35 weeks ago 25 | 180961 | Limbic~Region | 38012 | Chancellor (21) | 2960 | 2002-07-11 06:53:00 | 1 week ago 26 | 104919 | perrin | 36242 | Chancellor (21) | 4171 | 2001-08-15 04:13:00 | 2 years ago 27 | 114691 | Aristotle | 35627 | Chancellor (21) | 5335 | 2001-09-26 01:49:00 | 20 weeks ago 28 | 2680 | davorg | 34015 | Chancellor (21) | 2988 | 2000-02-02 01:01:00 | 4 weeks ago 29 | 58196 | Fletch | 33799 | Chancellor (21) | 3608 | 2001-02-13 23:08:00 | 2 days ago 30 | 80749 | tachyon | 32350 | Chancellor (21) | 3268 | 2001-05-16 03:26:00 | 10 years ago 31 | 186362 | adrianh | 32159 | Chancellor (21) | 2205 | 2002-07-30 20:57:00 | 2 years ago 32 | 44715 | graff | 31661 | Chancellor (21) | 3880 | 2000-12-04 02:04:00 | 2 weeks ago 33 | 108447 | demerphq | 31508 | Chancellor (21) | 3269 | 2001-08-28 18:16:00 | 1 year ago 34 | 248054 | Your Mother | 30978 | Chancellor (21) | 2536 | 2003-04-04 13:42:00 | 14 hours ago 35 | 534893 | Gavin | 30799 | Chancellor (21) | 598 | 2006-03-07 12:15:00 | 2 hours ago 36 | 533863 | roboticus | 30531 | Chancellor (21) | 2888 | 2006-03-02 12:31:00 | 7 hours ago 37 | 176576 | eyepopslikeamosquito | 30092 | Chancellor (21) | 1295 | 2002-06-23 06:02:00 | 13 minutes ago 38 | 442602 | planetscape | 30055 | Chancellor (21) | 1290 | 2005-03-27 09:28:00 | 2 days ago 39 | 524150 | syphilis | 29621 | Canon (20) | 2714 | 2006-01-19 07:30:00 | 4 hours ago 40 | 157432 | Joost | 29453 | Canon (20) | 3245 | 2002-04-08 13:32:00 | 3 years ago 41 | 708738 | LanX | 29231 | Canon (20) | 4599 | 2008-09-03 12:42:00 | 3 hours ago 42 | 1936 | japhy | 29144 | Canon (20) | 2347 | 2000-01-10 19:44:00 | 42 weeks ago 43 | 224409 | borisz | 27898 | Canon (20) | 913 | 2003-01-05 14:23:00 | 3 weeks ago 44 | 190859 | bart | 27165 | Canon (20) | 2611 | 2002-08-17 14:36:00 | 51 weeks ago 45 | 528646 | Khen1950fx | 26518 | Canon (20) | 1899 | 2006-02-07 22:12:00 | 12 hours ago 46 | 510280 | shmem | 26470 | Canon (20) | 2519 | 2005-11-20 20:58:00 | 19 hours ago 47 | 421114 | Tanktalus | 26170 | Canon (20) | 2178 | 2005-01-10 22:07:00 | 1 day ago 48 | 123953 | strat | 26010 | Canon (20) | 538 | 2001-11-08 03:38:00 | 2 years ago 49 | 832495 | choroba | 25807 | Canon (20) | 3418 | 2010-04-02 15:13:00 | 16 minutes ago 50 | 194920 | diotalevi | 25716 | Canon (20) | 3030 | 2002-09-03 22:06:00 | 3 years ago (50 rows)