From: Joshua D. Drake <jd@commandprompt.com>
To: [S] Dhandapani <dhandapani_s@sifycorp.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help on restoration
Date: Wed, 03 May 2006 15:34:17 -0700
Message-ID: <44592FE9.1000005@commandprompt.com> (raw)
In-Reply-To: <4459232A.6090104@sifycorp.com>
References: <4459232A.6090104@sifycorp.com>
[S] Dhandapani wrote:
> Hi,
>
> How to take dump based of condition i.e using where clauses in postgres?
>
> For example i want to take dump of 1 week data from my table y and
> import that 1 week data in to the same table after truncating the table
>
> my table name is y having field name date and my query is of select
> * from y where date >'2006-04-12';
>
CREATE TABLE foo as SELECT * FROM y WHERE data > '2006-04-12';COPY Y TO
'/tmp/y';
Joshua D. Drake
> how should i import the data taken using select statement using where
> condition in postgres.
>
>
> Regards,
> Dhandapani.
> ********** DISCLAIMER **********
> Information contained and transmitted by this E-MAIL is proprietary to
> Sify Limited and is intended for use only by the individual or entity to
> which it is addressed, and may contain information that is privileged,
> confidential or exempt from disclosure under applicable law. If this is
> a forwarded message, the content of this E-MAIL may not have been sent
> with the authority of the Company. If you are not the intended
> recipient, an agent of the intended recipient or a person responsible
> for delivering the information to the named recipient, you are notified
> that any use, distribution, transmission, printing, copying or
> dissemination of this information in any way or in any manner is
> strictly prohibited. If you have received this communication in error,
> please delete this mail & notify us immediately at admin@sifycorp.com
>
> Watch India vs. England LIVE, Hot videos and more only on Sify Max!
> Click Here. www.sifymax.com
>
> Get to see what's happening in your favourite City on Bangalore Live!
> www.bangalorelive.in
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, dhandapani_s@sifycorp.com
Subject: Re: Help on restoration
In-Reply-To: <44592FE9.1000005@commandprompt.com>
References: <4459232A.6090104@sifycorp.com> <44592FE9.1000005@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox