How do you do a simple begin-end statement block inside of a psql session?
For Example, I want to...
- begin
- declare a variable x to be an integer. Set it = 5
- declare s to be a varchar(8). Set it to “foo”
- insert into mytable (theint,thestr) values (x.s);
- end
I can do it in a formal declaration of a procedure, and then execute the procedure. But is there a less formal way?
Thanks
-dave
