Search
 
SCRIPT & CODE EXAMPLE
 

SQL

psql lst trigger

select event_object_schema as table_schema,
       event_object_table as table_name,
       trigger_schema,
       trigger_name,
       string_agg(event_manipulation, ',') as event,
       action_timing as activation,
       action_condition as condition,
       action_statement as definition
from information_schema.triggers
group by 1,2,3,4,6,7,8
order by table_schema,
         table_name;
Code has been copied
Comment

PREVIOUS NEXT
Code Example
Sql :: sql eliminare un record 
Sql :: add column in mysq 
Sql :: Sql query to force the database to be drop 
Sql :: stop psql server windows 
Sql :: xampp mysql database not starting 
Sql :: pyodbc connect to sql server 
Sql :: mysql set field unique 
Sql :: sql decrement value by 1 if not null or zero 
Sql :: how to delete view in sql 
Sql :: how much every mysql database record takes from diskspace 
Sql :: select item.* as json mysql 
Sql :: mysql delete binlog 
Sql :: sql reset auto increment 
Sql :: delete triger pl pg sql 
Sql :: oracle synonym 
Sql :: query any digits record 
Sql :: encoding UTF8 has no equivalent in encoding WIN1252 
Sql :: age postgres 
Sql :: mysql full outer join java 
Sql :: mysql month name extract 
Sql :: show table columns 
Sql :: create column mysql terminal 
Sql :: dbms_output.put_line 
Sql :: postgresql if null then 0 
Sql :: v$session not found in oracle 
Sql :: asp.net core with postgresql deploy on ubuntu 
Sql :: get table column names sql laravel 
Sql :: postgres convert text to number 
Sql :: mysql select where not in multiple tables 
Sql :: postgresql restore from dump 
ADD CONTENT
Topic
Content
Source link
Name
2+2 =