Aasimon.org Wiki

User Tools

Site Tools

Trace:
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
Next revisionBoth sides next revision
postgres:postgresql [2009/04/06 08:11] – devapostgres:postgresql [2010/06/01 11:02] – deva
Line 1: Line 1:
 ======PostGreSQL====== ======PostGreSQL======
 +=====Open sql cli interface======
 +<code>
 +psql -U [username] -W [database]
 +</code>
 +
 =====Creating/Deleting users===== =====Creating/Deleting users=====
 <code> <code>
Line 13: 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> </code>
postgres/postgresql.txt · Last modified: 2011/01/25 07:44 by deva