Date: Mon, 16 Nov 2015 13:47:52 +0530 (IST)
Subject: how to take export of one year data from large database which contain
 4 years of data.
From: clingareddy@vsoftcorp.com
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_20151116134752000000_60973"
Importance: Normal
Message-ID: <1447661872.857322350@apps.rackspace.com>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

------=_20151116134752000000_60973
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable


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 c=
ondition 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, distrib=
ute 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 opini=
ons presented in this email are solely those of the author and do not neces=
sarily 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 responsibilit=
y for any loss or damage arising from the use of this email or attachments.
------=_20151116134752000000_60973
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<font face=3D"verdana" size=3D"2"><p style=3D"margin:0;padding:0;font-famil=
y: verdana; font-size: 10pt; word-wrap: break-word;">Hi All,</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">&nbsp;</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">My database contains 4 years of data, but i want to&nbsp=
;migrate&nbsp;only one year i.e 2015 of data to another database.</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">&nbsp;</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">Please help me how to take export of one year data. Is t=
here any bus_date condition we can use while exporting?&nbsp;</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">&nbsp;</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">Thanks,</p>
<p style=3D"margin:0;padding:0;font-family: verdana; font-size: 10pt; word-=
wrap: break-word;">Chandrakiran L</p></font>

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, distrib=
ute 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 opini=
ons presented in this email are solely those of the author and do not neces=
sarily 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 responsibilit=
y for any loss or damage arising from the use of this email or attachments.
------=_20151116134752000000_60973--