dump a table in windows

Поиск
Список
Период
Сортировка
Искать

dump a table in windows

От:
Laurette Cisneros <laurette@nextbus.com>
Дата:

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.

Re: dump a table in windows

От:
"Devinder K Rajput" <Devinder.Rajput@ipaper.com>
Дата:

Have you tried pg_dump. Command should look something like

pg_dump  -t table_name db_name > output_file_name

Let me know if this works.  Thanks.

Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474


                                                                                                                           
                    Laurette Cisneros                                                                                      
                           To:     pgsql-admin@postgresql.org                                        
                    Sent by:                     cc:                                                                       
                    pgsql-admin-owner@post       Subject:     [ADMIN] dump a table in windows                              
                    gresql.org                                                                                             
                                                                                                                           
                                                                                                                           
                    09/24/2002 07:33 PM                                                                                    
                                                                                                                           
                                                                                                                           





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.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html




FAQ