postgres:postgresql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
postgres:postgresql [2010/07/05 15:22] – deva | postgres:postgresql [2011/01/25 07:44] (current) – deva | ||
---|---|---|---|
Line 30: | Line 30: | ||
< | < | ||
SELECT foo.xcpr FROM (SELECT a.personid AS xcpr, b.personid AS ycpr FROM examinations AS a LEFT OUTER JOIN person AS b ON a.personid = b.personid) AS foo WHERE foo.ycpr IS NULL; | SELECT foo.xcpr FROM (SELECT a.personid AS xcpr, b.personid AS ycpr FROM examinations AS a LEFT OUTER JOIN person AS b ON a.personid = b.personid) AS foo WHERE foo.ycpr IS NULL; | ||
+ | </ | ||
+ | |||
+ | =====Disable pager (less/more) in psql===== | ||
+ | < | ||
+ | \pset pager | ||
</ | </ |
postgres/postgresql.1278336178.txt.gz · Last modified: 2010/07/05 15:22 by deva