Re: Exporting results from query window to a file

We do use File->Export.

Encoding I have the radio button set to Local charset.
The database is utf-8.

Quoting all columns, including column names, quote character ", Column separator is a comma.

Row separator is LF

I normally export to a network drive.

I will get together with my co-worker and see if we can determine which table(s) might
be common to the queries.

Since it normally works if you cut and paste the same query into a new window, execute
and export from the new window I was leaning toward something else other than encoding.

Mike

On Tue, 05 Dec 2006 11:05:31 +0000, Dave Page wrote
> mike wrote:
> > Hello,
> > 
> > Has something changed from 1.4 to 1.6 in how pgadmin exports files?  In
> > 1.6 RC1 I have had issues when exporting the results of a query to a
> > file that
> >  A) I get the dialog box that says the Export completed sucessfully
> >  B) Upon opening the file I find it is damaged because the results were
> > not completely exported.  Maybe on row 66 the end of the line is not
> > present.  The file should have had over 100 rows. 
> >  C) Running it again from the same query window the results noted in A
> > and B occur again but the actual number of rows written to the file are
> > completely different. Usually a fewer amount of rows get exported.
> >  D) Copying and pasting the same query into a new query window, running
> > the query, and then exporting the data works successfully.
> > 
> > I have a co-worker who also had the same problems with the final release
> > of 1.6.
> > 
> > I have not tried 1.6.1 but it didn't appear that the changes made
> > between 1.6.1 and 1.6 would have affected this.
> > 
> > Client platform is WinXP SP2 and Database platform is Win2003.
> > 
> > I cannot reproduce this consistently.
> 
> There were some changes to check that data was converted to the correct 
> encoding correctly, and to correct a race issue over slow networks where 
> the data export may complete before all the data has actually been 
> retrieved from the server.
> 
> How are you executing the export - from the file menu on the query tool? 
> What encoding are you using?
> 
> Is there a small dataset that fails often enough that you could package 
> it as a test case for me to look at?
> 
> Regards, Dave
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


--
Open WebMail Project (http://openwebmail.org)