Re: Help on restoration - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Help on restoration
Date
Msg-id 44592FE9.1000005@commandprompt.com
Whole thread Raw
In response to Help on restoration  ("[S] Dhandapani" <dhandapani_s@sifycorp.com>)
List pgsql-admin
[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/



pgsql-admin by date:

Previous
From: "[S] Dhandapani"
Date:
Subject: Help on restoration
Next
From: Manlio Perillo
Date:
Subject: Re: audit table containing Select statements submitted