Re: Writing freebcp output to a pipe or STDOUT?
Igor Korot <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, On Tue, Apr 12, 2011 at 5:00 PM, James K. Lowden <[email protected]> wrote: > On Sun, 10 Apr 2011 01:31:20 -0400 > <[email protected]> wrote: > >> Is it possible to direct the output of freebcp to a names pipe or to >> STDOUT? ... or does it always have to write to a disk file? > > Most systems nowadays support /dev/stdout: > > $ freebcp systypes out /dev/stdout -c -t'|' ... | head -3 > bigint|127|0|127|8|19|0|0|0|1|0||0|0|1|63||19|0| > binary|173|2|173|8000|0|0|0|0|1|0||3|0|1|45||8000|| > bit|104|0|104|1|1|0|0|0|1|0||16|0|1|50||1|0| > > To a named pipe works, too, of course. > > >From a named pipe does not, unfortunately, because freebcp seeks over > the file while parsing it. However, you can probably write a small Perl script to achieve this. ;-) Thank you. > > HTH. > > --jkl > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds >