Lalit Kapoor

Coding | AI | Search Engine Technology | Recommendations
twitter: Internet Explorer - I hate you.
Jun 23

PostgreSQL - Dump and Restore

databases Add comments
To dump data from a postgreSQL database you can use the pg_dump command as follows

pg_dump database > file.sql

 

To restore that data you can execute the following command

psql -d database -f file.sql -U db_username
Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • DZone
  • del.icio.us
  • Technorati
  • Furl
  • Facebook
  • Google
  • Mixx
  • Sphinn
  • StumbleUpon
 

Leave a Reply