CODEWITHSUNDEEP
monetdb
Sahas
Sahas

Reputation: 11419

MonetDB storage() function

From MonetDB docs https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/storage-model, 

The storage footprint for any given database schema
can be obtained by inspecting the table producing 
function storage()

Here's a sample query from the documentation:

select * from storage() where "table" = 'lineitem';

But when I try a similar query, I get below error:

SELECT: no such operator 'storage'

What am I missing?

Upvotes: 2

Views: 155

Answers (1)

Nicolas Riousset
Nicolas Riousset

Reputation: 3619

Prefixing the storage() function call with the "sys" schema may solve your issue. Ex :

select * from sys.storage() where "table" = 'lineitem';

Upvotes: 4

Related Questions