Re: Need help on how to backup a table

From: ashish <ashish(dot)karalkar(at)netcore(dot)co(dot)in>
To: ajcity <victor(dot)aluko(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help on how to backup a table
Date: 2008-03-28 07:48:07
Message-ID: 47ECA2B7.9020103@netcore.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ajcity wrote:
>
>
> CAJ CAJ wrote:
>
>> Have you looked at "pg_dump -t"
>> http://www.postgresql.org/docs/8.2/static/app-pgdump.html
>>
>> Joey
>>
>>
>>
>
> Thanks for quick response but "pg_dump" does not allow me to dump from a
> SQL SELECT query which is what I wanna do.
>
>

May be selective COPY will help you.
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html

With regards
Ashish

===================================================================

sms START NETCORE to 575758 to get updates on Netcore's enterprise
products and services

sms START MYTODAY to 09845398453 for more information on our mobile
consumer services or go to http://www.mytodaysms.com

===================================================================

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-03-28 08:03:35 Re: Persistent user-defined functions
Previous Message pgsql-general-owner 2008-03-28 07:31:34 [pgsql-general] Daily digest v1.8035 (19 messages)