clingareddy@vsoftcorp.com wrote:
> My database contains 4 years of data, but i want to migrate only one year i.e 2015 of data to another
> database.
>
> Please help me how to take export of one year data. Is there any bus_date condition we can use while
> exporting?
PostgreSQL does not know when a row was created.
If you want to export only part of a table, you can do that with:
COPY (SELECT <part of the table>) TO <filename>;
You'd have to come up with appropriate SELECT statements for each affected table,
and you would end up with one export file per table.
A bit tedious, but it can be done.
Another option would be to create a copy of the database, delete everything
that is old and dump the remaining data.
Yours,
Laurenz Albe
