![]() Who works for us when they must pay for it? RAISE EXCEPTION '% cannot have null salary', NEW.empname RAISE EXCEPTION 'empname cannot be null' Check that empname and salary are given This script creates a new Table along with a Function and Trigger.Ĭopy the following text into your new SQL script:ĬREATE FUNCTION emp_stamp() RETURNS trigger AS $emp_stamp$ Select the “SQL” pull down on the toolbar and select “New SQL Script” (or use Ctrl+J). If you have created the two Docker PostgreSQL databases, run the following script on one of the instances. If your current database already has one or more objects, you can skip to the next step. This allows me to verify I have entered my database information correctly. I appreciate the “Test Connection” button on the new Database Connection UI. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |