Create PostgreSQL backup files with timestamp

Question

I'm doing a dump like this pg_dump prod-db -U postgres > prod-db.sql, but would be cool if I could do a dump like pg_dump prod-db -U postgres > prod-db-{date}.sql and be able to generate a file like prod-db-06-02-13.sql via shell...
I have no idea on how to start nor where to looking for. Any ideas, links, docs would be much appreciated.

Answer 1

Try this:

pg_dump prod-db -U postgres > prod-db-$(date +%d-%m-%y).sql

Here's the date manual, for other format options.

Answer 2

Use backticks and the date command.

i.e.

pg_dump prod-db -U postgres > prod-db-`date +%d-%m-%y`.sql