Re: input data libreoffice calc to postgreSQL Databases

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.
---------------------------------------------------------------

In response to

Browse pgsql-novice by date

  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