[postgis-users] SQL Dump Question

[Sean Montague]

This is more of a straight postgreSQL question, but does pertain to a 
postGIS table. I want to dump a very large table into separate tables by 
year. For instance, SELECT * FROM dg WHERE date = '2002';, and dump the 
result into a sql file, preferably with inserts into a table named dg2002.

Thanks!
Sean