Thread: input data libreoffice calc to postgreSQL Databases

input data libreoffice calc to postgreSQL Databases

From
Morovikov Vladimir
Date:
Dear Colleagues!How to enter data libreoffice calc in postgresql( Linux)?Best regards,Vladimir.

Re: input data libreoffice calc to postgreSQL Databases

From
Daniel Staal
Date:
--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.
---------------------------------------------------------------