Help converting constraint triggers

[Chris Hoover <revoohc@xxxxxxxxx>]

I need some help understanding how to convert constraint triggers to
normal foreign keys.  I have several of them in my database that a
previous dba created.  Since they don't show up in most PostgreSQL
tools, they are becoming a real pain to deal with.

Here is an example of on of the constraint triggers:
CREATE CONSTRAINT TRIGGER sys_user_group_id_fkey
    AFTER INSERT OR UPDATE ON sys_user
    FROM sys_group
    NOT DEFERRABLE INITIALLY IMMEDIATE
    FOR EACH ROW
    EXECUTE PROCEDURE "RI_FKey_check_ins" ('sys_user_group_id_fkey',
'sys_user', 'sys_group', 'UNSPECIFIED', 'group_id', 'group_id');


I believe this is the same as the foriegn key definition,

alter table sys_user 
  add constraint sys_user_group_id_fkey foreign key(group_id)
  references sys_group(group_id)
  not deferrrable;

Is this correct?  If not, how would be proper foreign key be defined?

Thanks,

Chris