how to take export of one year data from large database which contain 4 years of data. - Mailing list pgsql-admin

From clingareddy@vsoftcorp.com
Subject how to take export of one year data from large database which contain 4 years of data.
Date
Msg-id 1447661872.857322350@apps.rackspace.com
Whole thread Raw
Responses Re: how to take export of one year data from large database which contain 4 years of data.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: how to take export of one year data from large database which contain 4 years of data.  (Thomas Kellerer <spam_eater@gmx.net>)
List 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.

pgsql-admin by date:

Previous
From: 张文升
Date:
Subject: Re: [BUGS] postgresql downgrade issue
Next
From: Albe Laurenz
Date:
Subject: Re: how to take export of one year data from large database which contain 4 years of data.