PostgreSQL SQL - regarding debugging?

Author

regarding debugging?

AKHILESH GUPTA

2006-01-30, 3:23 am

hi all,
i have a query regarding debbuging in PGSQL.
just like there is a debugger in C/C++, where we can check the execution of
our program or we can dry run our code, is there aby option or feature with
PGSQL for the same purpose that we can check our PGSQL statements?
thanks in advance................................................!!
(waiting for your response)

--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

BigSmoke

2006-02-08, 1:24 pm

Checking how your PgSQL statements are executed, can be done using
EXPLAIN [1].

EXPLAIN ANALYZE will also execute (but not dry-run!) your statement.

I work with a seperate development and production database. Once the
changes to the schema in the development DB are done, I commit them to
the production DB using ActiveRecord migrations. You could do the same
with an advanced schema diff tool such as pgdiff [2] or zongle [3].

- Rowan

[1] http://www.postgresql.org/docs/curr...ql-explain.html
[2] http://pgdiff.sourceforge.net/
[3] http://zongle.sourceforge.net/

Sponsored Links