Re: pgsql->ms excel

On Tue, Feb 19, 2002 at 01:26:31PM +0100, pilsl@goldfisch.at wrote:
> Is there some ready2use or almostready2use-solution for converting a
> pgsql-table into a ms-excel .xls-file ?
>
> I dont think its a big deal using the appropriate perl-module but if
> someone already did the work, I dont want to do it again.
>  If nobody did it : I'll do it and post it here if I succeed.

Method 1.

psql dbname -F, -A -t -c 'select * from table' > table.csv

You can load it into excel then. You can replace the comma with a tab (if
you quote appropriately)

Method 2.

Install ODBC driver in MS Access, link the table, open it and export as .xls

HTH,

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.