Skip to content

Instantly share code, notes, and snippets.

@ramiroaznar

ramiroaznar/query.sql

Created November 1, 2016 10:17
Show Gist options
  • Save ramiroaznar/c0947649ccb04b0368ec930c4712af12 to your computer and use it in GitHub Desktop.
Save ramiroaznar/c0947649ccb04b0368ec930c4712af12 to your computer and use it in GitHub Desktop.
Download ZIP
How to get the list of tables of CARTO user
Raw
query.sql
/* showing all user tables */
select * from CDB_UserTables()
/* showing tables with a specific name */
with a as (select * from CDB_UserTables())
select * from a where cdb_usertables ilike 'table_name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment