swateek/lakebase_postgres_helper.md

Created August 4, 2026 09:38

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/swateek/bfe5663e0f9996874edf7d02fb67aae0.js"></script>
Save swateek/bfe5663e0f9996874edf7d02fb67aae0 to your computer and use it in GitHub Desktop.

Download ZIP

Working With Lakebase Postgres

Raw

lakebase_postgres_helper.md

Listing All Tables In Database

-- List all tables in the current database (all schemas)
SELECT schemaname, tablename
FROM pg_catalog.pg_tables
WHERE schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY schemaname, tablename;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment