Postgres Pro
Downloads
Home   >   mailing lists

Thread: begin-end blocks in psql

begin-end blocks in psql

From
"Gauthier, Dave"
Date:

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

 

 

 

Re: begin-end blocks in psql

From
"Rodrigo E. De León Plicet"
Date:
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.