Import an Excel table to a Postgresql one

[Daniele Beauquier]

How to import an Excel table into a Postgresql table in a simple way?
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Peter Eisentraut]

Daniele Beauquier wrote:

How to import an Excel table into a Postgresql table in a simple way?

Export into a text file and import using COPY.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Bruno Wolff III]

On Fri, Sep 17, 2004 at 18:50:53 +0200,
Daniele Beauquier <be*******@univ-paris12.fr> wrote:

How to import an Excel table into a Postgresql table in a simple way?

Export it into CSV or TSV format and then use \copy in psql to load it.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match