As you can see, we have currently working on port 5432 as default you can also change it. Add the database name you want to work on, otherwise, leave it as it is and tap enter. ![]() ![]() Change the server if you want to work on another server, or else press enter from your keyboard. To understand the trigger concept briefly, launch the PostgreSQL shell from the applications. Table-name: Specifies the table upon which trigger will be constructed.Event_name: Title of the occurrence which might set off the trigger (This could be, whether from INSERT or UPDATE or DELETE).BEFORE, AFTER, INSTEAD OF: Terms that decide when the trigger would be active.Here is the explanation of the above general query. CREATE TRIGGER trigger_name event-name ON table_name
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |