Re: [GENERAL] Command line export or copy utility?

2007-06-18 Thread Francisco Reyes
Reece Hart writes: On Tue, 2007-05-22 at 18:07 -0400, Francisco Reyes wrote: Does anyone know of any export or copy utility that runs on FreeBSD? I basically need a program that will connect to one database, do a select and copy the result to a second database. Two options: 1) if you want a

Re: [GENERAL] Command line export or copy utility?

2007-05-22 Thread Reece Hart
On Tue, 2007-05-22 at 18:07 -0400, Francisco Reyes wrote: > Does anyone know of any export or copy utility that runs on FreeBSD? > I basically need a program that will connect to one database, do a > select and copy the result to a second database. Two options: 1) if you want a whole table or sc

Re: [GENERAL] Command line export or copy utility?

2007-05-22 Thread Brent Wood
Francisco Reyes wrote: Does anyone know of any export or copy utility that runs on FreeBSD? I basically need a program that will connect to one database, do a select and copy the result to a second database. There are a few ways, from memory (so I might have the odd syntax error): To replica

Re: [GENERAL] Command line export or copy utility?

2007-05-22 Thread Scott Ribe
Use psql; it provides all the command-line options you need. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresq

[GENERAL] Command line export or copy utility?

2007-05-22 Thread Francisco Reyes
Does anyone know of any export or copy utility that runs on FreeBSD? I basically need a program that will connect to one database, do a select and copy the result to a second database. Alternatively a tool which would export the data in a format suitable to be loaded by psql is just fine. F