postgres:postgresql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
| postgres:postgresql [2010/05/31 14:03] – deva | postgres:postgresql [2010/07/05 15:22] – deva | ||
|---|---|---|---|
| Line 2: | Line 2: | ||
| =====Open sql cli interface====== | =====Open sql cli interface====== | ||
| < | < | ||
| - | psql -U [username] -W [password] | + | psql -U [username] -W [database] |
| </ | </ | ||
| Line 25: | Line 25: | ||
| < | < | ||
| ALTER TABLE data ALTER COLUMN filename TYPE character varying(255) USING substring(filename from 20); | ALTER TABLE data ALTER COLUMN filename TYPE character varying(255) USING substring(filename from 20); | ||
| + | </ | ||
| + | |||
| + | =====Find missing foreign key values===== | ||
| + | < | ||
| + | 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; | ||
| </ | </ | ||
postgres/postgresql.txt · Last modified: 2011/01/25 07:44 by deva