Friday, 9 September 2022

Postgresql - List all tables

SELECT 

    TABLE_NAME 

FROM INFORMATION_SCHEMA.TABLES 

WHERE 

    TABLE_SCHEMA = 'mydatabase' 

    AND 

    TABLE_TYPE = 'BASE TABLE' 

ORDER BY TABLE_NAME

No comments:

Snowflake - Notes

WPRKSPACES -  In September 2025, Snowflake introduced Workspaces, which combines the functionality of Worksheets, Notebooks, File Manager, Q...