Thank you very much for your reply, I will try this script. Donatas
-----Original Message----- From: Alexei Novakov [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 9:11 PM To: Donatas Ciuksys; MaxDB mailing list. Subject: Re: dump table data as SQL insert statements Find the attached script. I used it just for the same thing. It dumps the whole table into bunch of insert statements. It takes some time to process dabase output, and maybe there is a better way to this, but I didn't find any. Actually it works in two steps a) does "select * from table_name" using sqlcli, and b) translates the output into insert statements using streaming editor sed. I am running the script in cygwin under windows, it should be easily portable into any unix like system. Best regards. Alexei --- Donatas Ciuksys <[EMAIL PROTECTED]> wrote: > Hello, > > I would like to know whether there is some way to > export table data (not > catalog) as SQL insert statements (not as PAGES or > CSV). > > Regards, > > Donatas Ciuksys > Vilnius University, > Department of Informatics > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Search - Find what youre looking for faster http://search.yahoo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
