5

How to dump a part of a table from PostgreSQL?

view full story
linux-howto

http://serverfault.com – I have a PostgreSQL database with a multi-Gb table (which contains a log of certain events). I need to pass the latest events to an analyst - let's say he only needs events from the last month. How can I produce a dump of only those rows that have, say, created_at > '2012-05-01'? (HowTos)