Re: Exporting results from query window to a file

From: Dave Page <dpage(at)postgresql(dot)org>
To: mike(at)thegodshalls(dot)com
Cc: PG Admin <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Exporting results from query window to a file
Date: 2006-12-05 16:28:45
Message-ID: 45759E3D.5050309@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Mike G wrote:
> 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.

Yeah, I was erring towards the race issue, but that bug was outputting
the correct number of rows, just with no data in them (leaving rows and
rows of quotes and delimiters) iirc.

Might be worth trying the export to a local drive, thoughs that's
something of a shot in the dark.

Regards, Dave.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Marcel Schnippe 2006-12-05 22:22:50 Bugreport: de_de/tips.txt not unicode
Previous Message Mike G 2006-12-05 16:24:33 Re: Exporting results from query window to a file