Listing database objects in schema
Is there a way to list tables in a particular schema or even in all schemas? \d and \dt seem to only return user tables in the sys schema. Also, what does \ds return? I have \dS system tables \dt user tables \dv views \ds ????? \df functions \dn schemas Best, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://geospatial.commons.gc.cuny.edu/http://freecity.commons.gc.cuny.edu/
http://www.monetdb.org/Documentation/mclient-man-page
Lee Hachadoorian
Is there a way to list tables in a particular schema or even in all schemas? \d and \dt seem to only return user tables in the sys schema.
Also, what does \ds return?
I have
\dS system tables \dt user tables \dv views \ds ????? \df functions \dn schemas
Best, --Lee
-- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://geospatial.commons.gc.cuny.edu/http://freecity.commons.gc.cuny.edu/
------------------------------------------------------------------------
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sent from my Android phone with K-9 Mail. Please excuse my brevity.
On Fri, Dec 6, 2013 at 4:15 PM, Stefan Manegold
Thanks, --Lee
participants (2)
-
Lee Hachadoorian
-
Stefan Manegold