[ADMIN] anonymous block in Postgres - Hello World

[Abraham, Danny]

#!/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