|
From: Susan C. <hom...@ya...> - 2006-07-12 23:48:48
|
Hi Gerd, Thanks so much for your prompt response, I appreciate it and will look forward to the 2.3 final release! Regards, Susan ----- Original Message ---- From: Gerd Wagner <bir...@t-...> To: Susan Cline <hom...@ya...> Cc: squ...@li... Sent: Wednesday, July 12, 2006 2:18:38 PM Subject: Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file Hi Susan, at the moment SQuirreL does not offer exactly what you ask for. But it will maybe already in the 2.3 final release. All we can offer now is to export the content of an SQL result table. If your tables are small enough to be displayed by SQuirreL you may use this function. You need to have version 2.3 rc1. Then just right mouse click a result and choose the "export CSV" item. Gerd Susan Cline wrote: > Hi, > > I've looked in the documentation and the archives on a way to do this, but I've either missed it > or maybe it can not be done - I'm hoping someone can help. > > I'm trying to figure out how to export all of the data in a table to a 'load' file - something that > has delimeters that are appropriate for import. > > I tried all of the "Copy ..." functions available after selecting all rows and none seem to just > export the data. > > Is there a command to do this, or do I need to use the SQL window to issue the SQL command > manually for my specific database (Derby)? > > Thanks for your help! > > Susan > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
