Re: print command in sproc - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: print command in sproc
Date
Msg-id 92869e660710300502t1fd5fd8ar6e718c41fa6c0cb@mail.gmail.com
Whole thread Raw
In response to Re: print command in sproc  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Fragments in tsearch2 headline
Next
From: "Pit M."
Date:
Subject: Re: Problems with PostgreSQL DBI-Link / DBD-ODBC