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 revisionBoth sides next revision
postgres:postgresql [2010/02/18 11:51] – devapostgres:postgresql [2010/05/31 14:03] – deva
Line 20: Line 20:
 psql -U [username] -W [dbname] < 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