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
