To Know the list of database schema and their size Run below Sql Query SELECT schema_name,pg_size_pretty(sum(table_size)::bigint) as “disk space”,(sum(table_size) / pg_database_size(current_database())) * 100 as “percent”…
Leave a CommentCategory: postgressql
Storing large object files into database is much interesting then saving path of files. Large object data like images, document can be save into database…
Leave a CommentDynamic table name in PostgreSQL trigger used as “TG_TABLE_NAME” “TG_TABLE_NAME” is a name of the table that caused the trigger invocation. Like If you want…
Leave a CommentThis Tutorial introduces how to extract Information Schema in PostgreSQL with simple Sql queries. Information schema provides information about tables, columns, views, trigger, functions and…
Leave a Comment