On Thu, Mar 27, 2008 at 11:05 PM, ajcity <victor(dot)aluko(at)gmail(dot)com> wrote:
>
> Hi all,
> I am trying to backup a large table with about 6 million rows. I want to
> export the data from the table and be able to import it into another table
> on a different database server (from pgsql 8.1 to 8.2). I need to export
> the
> data through SQL query 'cause I want to do a gradual backup.
> Does pgsql have a facility for this?
> Thanks in advance for your reply.
>
>
Have you looked at "pg_dump -t"
http://www.postgresql.org/docs/8.2/static/app-pgdump.html
Joey