Thread: print command in sproc

print command in sproc

From

Goboxe

Date:

30 October 2007, 02:27:31

Hi,

What is the equivalent MSSQL 'print' command in pg sproc?

Thanks,
G

Re: print command in sproc

From

Jorge Godoy

Date:

30 October 2007, 03:24:40

Em Tuesday 23 October 2007 07:17:53 Goboxe escreveu:
> Hi,
>
> What is the equivalent MSSQL 'print' command in pg sproc?

What does the MSSQL 'print' command "prints"?

--
Jorge Godoy      <jgodoy@gmail.com>

Re: print command in sproc

From

"Filip Rembiałkowski"

Date:

30 October 2007, 12:02:37

2007/10/30, Jorge Godoy <jgodoy@gmail.com>:
> Em Tuesday 23 October 2007 07:17:53 Goboxe escreveu:
> > Hi,
> >
> > What is the equivalent MSSQL 'print' command in pg sproc?
>
> What does the MSSQL 'print' command "prints"?

It prints what you tell it to print :)

Goboxe: The key question is, what you need 'print' for?

For PL/PgSQL debugging, use RAISE NOTICE - or write your own logging functions

If you are using psql, and just want to emit some static text - use '\echo'

HTH.



--
Filip Rembiałkowski