begin-end blocks in psql

Started by Gauthier, Daveabout 18 years ago2 messagesgeneral
Jump to latest
#1Gauthier, Dave
dave.gauthier@intel.com

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

#2Rodrigo De León
rdeleonp@gmail.com
In reply to: Gauthier, Dave (#1)
Re: begin-end blocks in psql

On 3/21/08, Gauthier, Dave <dave.gauthier@intel.com> wrote:

I can do it in a formal declaration of a procedure, and then execute the
procedure. But is there a less formal way?

No. There are no anonymous blocks in PostgreSQL.