'Get all columns from a table in Monetdb

I have to study a table on monetdb that probably has many columns. When I do

SELECT * from cat.data limit 1;

I get

1 tuple !5600 columns dropped!

Which I interpret as not getting all the columns from the console.

I am using mclient to connect to the database.

I tried withe DESC, DESCRIBE - didnt work. Any help?

monetdb

Solution 1:^[1]

Indeed. See mclient --help It is possible to extend the width of your output to see more columns.

Alternatively, within the mclient console use the \d tablename command

You need to use \w-1 command before executing your query.

sql>\w-1
sql>SELECT * from cat.data limit 1 ;

This will show all the columns in the terminal. The text will be wrapped.

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	mkersten
Solution 2	Rahul Hindocha