User Tools

Site Tools


postgres:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
postgres:postgresql [2009/04/06 08:11] devapostgres:postgresql [2011/01/25 07:44] (current) deva
Line 2: Line 2:
 =====Open sql cli interface====== =====Open sql cli interface======
 <code> <code>
-psql -U [username] -W [password]+psql -U [username] -W [database]
 </code> </code>
  
Line 18: Line 18:
 =====Import/export a database====== =====Import/export a database======
 <code> <code>
-psql -U [username] -W [password] < dump.sql+psql -U [username] -W [dbname] < dump.sql
 pg_dump -U [username] -h localhost [-t [table]] [dbname] > dump.sql pg_dump -U [username] -h localhost [-t [table]] [dbname] > dump.sql
 +</code>
 +
 +=====Cut prefix from table=====
 +<code>
 +ALTER TABLE data ALTER COLUMN filename TYPE character varying(255) USING substring(filename from 20);
 +</code>
 +
 +=====Find missing foreign key values=====
 +<code>
 +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;
 +</code>
 +
 +=====Disable pager (less/more) in psql=====
 +<code>
 +\pset pager
 </code> </code>
postgres/postgresql.1238998303.txt.gz · Last modified: 2009/04/06 08:11 by deva