pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/





view thread (2+ messages)

Message-ID: <44592FE9.1000005@commandprompt.com>
Permalink:  ../44592FE9.1000005@commandprompt.com/
Also on:    postgresql.org/message-id/44592FE9.1000005@commandprompt.com

 · 

reply

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