Thread: [Squirrel-sql-users] Exporting all rows in a table to an sql file
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Susan C. <hom...@ya...> - 2006-07-12 20:41:15
|
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 |
From: Gerd W. <bir...@t-...> - 2006-07-12 21:17:06
|
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 > |
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 |
From: Robert M. <rob...@gm...> - 2006-07-13 00:24:06
|
On 7/12/06, Susan Cline <hom...@ya...> wrote: > > 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. > "delimiters that are appropriate for import" into what and using what tool? I could interpret this to mean import into another SQL database using SQL insert statements delimited by semi-colons. If that were the case, then right-click on a table and choose "Create Data Script". If what you are looking for is raw data (without SQL) then refer to Gerd's response. Rob |
From: Susan C. <hom...@ya...> - 2006-07-13 00:45:17
|
Hi Rob, You're right - I wasn't very clear stating what I wanted... but right now I would be happy with either way, and the way you suggested will work fine for now. I was thinking about something that did not include the insert statement itself, but was more of the format of: | row 1 data | row 2 data | However, the insert statements created the way you suggested will be fine. Thanks very much for your answer! Regards, Susan ----- Original Message ---- From: Robert Manning <rob...@gm...> To: Susan Cline <hom...@ya...> Cc: squ...@li...; hom...@pa... Sent: Wednesday, July 12, 2006 5:24:02 PM Subject: Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file On 7/12/06, Susan Cline <hom...@ya...> wrote: > > 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. > "delimiters that are appropriate for import" into what and using what tool? I could interpret this to mean import into another SQL database using SQL insert statements delimited by semi-colons. If that were the case, then right-click on a table and choose "Create Data Script". If what you are looking for is raw data (without SQL) then refer to Gerd's response. Rob |