On 24-03-2008 01:01:14 -0400, McKennirey.Matthew wrote:
Forgot environment: built 2008-03-22 from nightly=stable on Linux (OpenSusue 10.2)
# MonetDB server v5.4.0, based on kernel v1.220 # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
The database dump command does not appear to support schemas
As workaround for the moment you could try the jdbcclient's dump feature, which does handle schemas, but fails to properly dump all constraints on tables. You can find jdbcclient here: http://homepages.cwi.nl/~fabian/troep/jdbcclient.jar
./monetdb create TESTDB
successfully created database 'TESTDB'
./monetdb start TESTDB
./mclient --database=TESTDB --user=monetdb --passwd=monetdb -lsql
sql>CREATE SCHEMA abc;
sql>CREATE TABLE abc.T1 (col1 VARCHAR (32));
sql>CREATE TABLE abc.T2 (col1 VARCHAR (32));
sql>\q;
./mclient -lsql --database=TESTDB --dump >/local/monetdb/test-dump.sql
Table sys.t1 does not exist.
Table sys.t2 does not exist.
cat /local/monetdb/test-dump.sql
START TRANSACTION;
COMMIT;