how to take export of one year data from large database which contain 4 years of data.

From: clingareddy(at)vsoftcorp(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: how to take export of one year data from large database which contain 4 years of data.
Date: 2015-11-16 08:17:52
Message-ID: 1447661872.857322350@apps.rackspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi All,

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?

Thanks,
Chandrakiran L

Please do not print this email unless it is absolutely necessary.

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail and destroy all copies of this message and any attachments. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2015-11-16 08:31:39 Re: how to take export of one year data from large database which contain 4 years of data.
Previous Message 张文升 2015-11-16 02:37:09 Re: [BUGS] postgresql downgrade issue