| From: | Daniel Staal <DStaal(at)usa(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: input data libreoffice calc to postgreSQL Databases |
| Date: | 2014-12-12 17:55:45 |
| Message-ID: | 36AEF870761900076154E5EE@[192.168.1.50] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
--As of December 12, 2014 10:15:54 AM +0300, Morovikov Vladimir is alleged
to have said:
>
> Dear Colleagues!
> How to enter data libreoffice calc in postgresql( Linux)?
> Best regards,Vladimir.
--As for the rest, it is mine.
There's a lot of variables based on details you haven't mentioned, but in
general the simplest way is probably to export the spreadsheet into a CSV
file and then import it into an appropriate table, using the COPY command.
Daniel T. Staal
---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Robertson | 2014-12-14 14:15:36 | work copying over to closed servers and databases |
| Previous Message | Morovikov Vladimir | 2014-12-12 07:15:54 | input data libreoffice calc to postgreSQL Databases |