[SQL] how to use pgsql like mssql

[liuzg2]

in the pgadmin edit
i want use
declare  ...
if exists ...
insert something if @@rowcout>0 then do something
if ....
like in mssql and not use function
how to
sorry for my english