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: | Raw Message | Whole Thread | 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 |