dump a table in windows

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: dump a table in windows
Date: 2002-09-25 00:33:17
Message-ID: Pine.LNX.4.44.0209241730350.7170-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I need to dump a table from a database on a server on another system into a
file from a client on windows.

I've tried using pgadminII and issuing a copy command but it runs dog slow!

I've tried using Python/pyPgSQL by querying the records from the table and
writing them to a file and it runs dog slow!

I can't compile psql because I don't have MS C++.

Any other ideas on what I can do or how to speed up any of these?

Thanks,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
-----------------------------------
NextBus say:
Riders prefer to arrive just minute
before bus than just minute after.

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2002-09-25 09:01:33 LWLockAcquire
Previous Message Laurette Cisneros 2002-09-24 23:33:37 Re: command line client on windows?