SELECT * FROM your_table_name;
SELECT * FROM your_table WHERE case_id = 'your_case_id';
SELECT * FROM pg_catalog.pg_logs WHERE log_time >= 'your_error_time';
REINDEX TABLE your_table_name;
SELECT prosrc FROM pg_proc WHERE proname = 'your_procedure_name';
SELECT grantee, privilege_type FROM information_schema.role_table_grants WHERE table_name='your_table_name';
SELECT * FROM pg_trigger WHERE tgrelid = 'your_table_name'::regclass;
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)