[MonetDB-users] Dump schema w/ mclient?
Is there a way to user mclient to dump the db schema without dumping the data? I tried creating a one line SQL file with \d <tablename> and piping to mclient stdin, but it didn't work. Thanks, m
On 2010-10-04 14:17, Mark Bucciarelli wrote:
Is there a way to user mclient to dump the db schema without dumping the data?
I tried creating a one line SQL file with
\d <tablename>
and piping to mclient stdin, but it didn't work.
Instead of mclient, use msqldump --describe -- Sjoerd Mullender
On 04-10-2010 15:00:58 +0200, Sjoerd Mullender wrote:
On 2010-10-04 14:17, Mark Bucciarelli wrote:
Is there a way to user mclient to dump the db schema without dumping the data?
I tried creating a one line SQL file with
\d <tablename>
and piping to mclient stdin, but it didn't work.
Instead of mclient, use msqldump --describe
alternatively your original approach didn't work, because the \X commands are only recognised in interactive mode. If you'd force the client to go interactive (-i), it should recognise the \d command.
participants (3)
-
Fabian Groffen -
Mark Bucciarelli -
Sjoerd Mullender