postgresql/backups

http://www.postgresql.org/docs/7.4/static/app-pgdump.html

To dump a database called mydb that contains large objects to a tar file:

$ pg_dump -Ft -b mydb > db.tar

To reload this database (with large objects) to an existing database called newdb:

$ pg_restore -d newdb db.tar

One table

pg_dump geogloria --attribute-inserts --column-inserts -t glo_temperaturas > temperaturas.sql