Subject | Re: [firebird-support] Export in console |
---|---|
Author | Milan Babuskov |
Post date | 2006-12-14T11:29:27Z |
jefrey mina wrote:
use "out" command to redirect output of SELECT to file, or you can
create an external table, INSERT records into it and then DROP it,
achieving a similiar effect (with perhaps cleaner format).
Also, take a look at FBExport. It's built specially for data
export/import from console. There are versions for Linux and Windows:
http://fbexport.sourceforge.net
--
Milan Babuskov
http://www.flamerobin.org
> Hi guys can you help me how can i export records using firebird console "isql.exe"Export to what? Textual files, CVS, XML? You have many options: you can
use "out" command to redirect output of SELECT to file, or you can
create an external table, INSERT records into it and then DROP it,
achieving a similiar effect (with perhaps cleaner format).
Also, take a look at FBExport. It's built specially for data
export/import from console. There are versions for Linux and Windows:
http://fbexport.sourceforge.net
--
Milan Babuskov
http://www.flamerobin.org