I have been trying to figure out how I can run a pgsql script like I can run
a plsql script with oracle's sqlplus.  Here is a sample script file for what
I want to run:

declare
  sysuserid integer := 0;
  hwcustid  integer := 0;
begin

select nextval( 'user_seq' ) into  sysuserid;
select nextval( 'customer_seq' ) into  hwcustid;

insert into user
(
  user_id,
  customer_id,
  create_user,
  update_user
)
values
(
  sysuserid,
  hwcustid,
  sysuserid,
  sysuserid
);

insert into customer
(
  customer_id,
  create_user,
  update_user
)
values
(
  hwcustid,
  sysuserid,
  sysuserid
);

commit;

end;

I try to run the script in psql and thru pgadmin and cannot seem to make
them work.  I do not want to turn it into a function.  I just want it to
execute the block in a fashion similar to Oracle'sqlplus running
@scriptfile.sql.

Thanks

Reply via email to