anonymous block in Postgres - Hello World - Mailing list pgsql-admin

From Abraham, Danny
Subject anonymous block in Postgres - Hello World
Date
Msg-id F8B9B12641FB6B4FAC761BDEF9D63B040CFB4680@tlv-ex-01.adprod.bmc.com
Whole thread Raw
Responses Re: anonymous block in Postgres - Hello World  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

#!/bin/sh

psql --quiet  -t << EOF

declare

   x varchar(80);

begin

   x:='Hello World';

   raise notice x;

end;

\q

EOF

 

======

 

Hi,

 

This code is my first “like Oracle anonymous blocl”. It does not go through.

 

Can anyone help?

 

Thanks

 

Danny

 

pgsql-admin by date:

Previous
From: Thomas Mack
Date:
Subject: Role based database access
Next
From: Alvaro Herrera
Date:
Subject: Re: Role based database access