On Thu, Mar 20, 2008 at 04:09:16PM -0400, McKennirey.Matthew wrote:
I was wondering if the COPY command does not support schemas?
CREATE TABLE test ( column1 VARCHAR(32), column2 VARCHAR(32) );
COPY INTO test FROM '/location/file.csv' USING DELIMITERS ',', '\n';
works fine
CREATE SCHEMA abc;
CREATE TABLE abc.test ( column1 VARCHAR(32), column2 VARCHAR(32) );
COPY INTO abc.test FROM '/location/file.csv' USING DELIMITERS ',', '\n';
fails with
!SQLException:sql:table test not found !SQLException:importTable:failed to import table Indeed this is a bug. Could you file it on the sourceforge bugtracker system?
Niels
INSERT into abc.test VALUES(one,two)
works fine
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl