Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help on how to backup a table - Mailing list pgsql-general

From ashish
Subject Re: Need help on how to backup a table
Date
Msg-id 47ECA2B7.9020103@netcore.co.in
Whole thread Raw
In response to Re: Need help on how to backup a table  (ajcity <victor.aluko@gmail.com>)
Responses Re: Need help on how to backup a table  (ajcity <victor.aluko@gmail.com>)
List pgsql-general
Tree view
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

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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Using tables in other PostGreSQL database
Next
From: David T
Date:
Subject: Persistent user-defined functions