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.txt · Last modified: 2011/01/25 07:44 by deva