INFORMATION_SCHEMA.TABLES Sistem Tablosu

Örnek

Açıklaması şöyle

Sometimes we need to create a temporary table during data migration or handle the issue which is usually safe to be dropped later on. We can check whether there is a name convention for temporary tables (like tmp_* , temp_* , *_backup , etc) within the organization.

Şöyle yaparız

SELECT table_catalog, table_schema, table_name, table_type
FROM information_schema.tables 
WHERE
  table_schema NOT IN ( 'pg_catalog', 'information_schema' )
  AND ( table_name LIKE 'tmp_%' OR table_name LIKE 'temp_%' OR table_name LIKE '%_backup' );