Differences

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

--- postgres:postgresql [2009/04/06 08:11] – deva
+++ postgres:postgresql [2010/07/05 15:22] – deva
@@ Line 1: / Line 1: @@
 ======PostGreSQL======
+=====Open sql cli interface======
+<code>
+psql -U [username] -W [database]
+</code>
 =====Creating/Deleting users=====
 <code>
@@ Line 13: / Line 18: @@
 =====Import/export a database======
 <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
+</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>