[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Turning echo on in Postgres, for debugging.

Posted on 2007-07-20
1
Medium Priority
?
279 Views
Last Modified: 2008-02-01
Any idea how to turn postgres echoing on, so when I run a simple function, I can see the lines of code execute?

0
Comment
Question by:gmanpert
1 Comment
 
LVL 10

Accepted Solution

by:
adrpo earned 750 total points
ID: 19544043

I don't think such thing is possible.
However, you could try to print some messages in the log to see what is going on in the function.
You use:
RAISE level 'format' [, expression [, ...]];
Possible levels are DEBUG, LOG, INFO, NOTICE, WARNING, and EXCEPTION.

In this example, the value of v_job_id will replace the % in the string:
RAISE NOTICE 'Calling cs_create_job(%)', v_job_id;

Read more here:
http://www.postgresql.org/docs/8.2/static/plpgsql-errors-and-messages.html

Cheers,
za-k/
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question