Thread: PostgreSQL 8.4 and up only: Load data from Excel files into PostgreSQL using CSV Loader
PostgreSQL 8.4 and up only: Load data from Excel files into PostgreSQL using CSV Loader
From
Adrian Wijasa
Date:
Hello: Due to a bug report from a PostgreSQL 8.3 user, I would suggest to use CSV Loader only with PostgreSQL 8.4 or higher. This could very likely happened because I learned PL/pgsql through a PostgreSQL 8.4.4 documentation. I'm planning to read the 8.3 documentation as the first step to solve this issue. Here is the reported error: I got the following error on pgAdminIII.(v1.8.4) PostgreSQL v8.3.3 Windows Vista Home Premium, java version "1.6.0_21" Java(TM) SE Runtime Environment (build 1.6.0_21-b07) ERROR: syntax error at or near "$1" LINE 1: $1 ^ QUERY: $1 CONTEXT: SQL statement in PL/PgSQL function "f_build_tbl_deps" near line 162 ********** Error ********** ERROR: syntax error at or near "$1" SQL STATE:42601 CONTEXT:SQL statement in PL/PgSQL function "f_build_tbl_deps" near line 162 I managed to reproduce the error he got in PostgreSQL 8.3 only. Thanks, Adrian Wijasa Developer CSV Loader Project awijasa@gmail.com ---------- Forwarded message ---------- From: Adrian Wijasa <awijasa@gmail.com> Date: Tue, Aug 24, 2010 at 10:19 PM Subject: Load data from Excel files into PostgreSQL using CSV Loader To: pgsql-announce@postgresql.org CSV Loader 2.1 has just been released at http://csvloader.sourceforge.net. It is a Java tool that loads/merges data from Excel CSV files into PostgreSQL through its JDBC3 interface. If you need a walkthrough of the program or encounter any trouble/bug, please don't hesitate to contact me at awijasa@gmail.com. Thanks! Adrian Wijasa Developer CSV Loader Project