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
http://www.monetdb.org/Documentation/mclient-man-page
Lee Hachadoorian Lee.Hachadoorian+L@gmail.com wrote:
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
participants (2)
-
Lee Hachadoorian
-
Stefan Manegold