| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | pilsl(at)goldfisch(dot)at |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgsql->ms excel |
| Date: | 2002-02-19 12:53:09 |
| Message-ID: | 20020219235309.C27403@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 19, 2002 at 01:26:31PM +0100, pilsl(at)goldfisch(dot)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(at)svana(dot)org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pilsl | 2002-02-19 12:54:04 | Re: pgsql->ms excel |
| Previous Message | Mourad EL HADJ MIMOUNE | 2002-02-19 12:51:12 | Large object maniplation |