2

I have Postgresql DB on my pc and I'm trying to connect different database application to Postgresql but before that(An research issue), for each application, I need to see all the input parameter and all the queries corresponding to those input parameter that application can do.

How?

Cœur
  • 37,241
  • 25
  • 195
  • 267
Alex
  • 117
  • 8
  • What application? If you need to do this without connecting it to a database then you'll need to look at the application itself. – Richard Huxton Dec 17 '12 at 08:19
  • did you have a look at [that question](http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries)? – didierc Dec 17 '12 at 12:00
  • That's the point! I need to do it without connecting the application to database and consider when the application is not open source there is no access to the code. Since checking one by one each single application is not feasible, I need a tool to do that for me. Obviously if exists. Thank you very much! – Alex Dec 17 '12 at 15:41

1 Answers1

0

Look in the code of every application and see what calls are being made. In addition figure out all the parameter values that can be sent based on an almost infinite combination of characters and numbers the user can select from.

Or to remain sane turn on postgresql logging and let the users do their thing and analyse what calls are being made.

Kuberchaun
  • 29,160
  • 7
  • 51
  • 59
  • That's the point! I need to do it without connecting the application to database and consider when the application is not open source there is no access to the code. Since checking one by one each single application is not feasible, I need a tool to do that for me. Obviously if exists. Thank you very much! – Alex Dec 17 '12 at 15:42
  • Let me know please if you any tool that can be helpful for me. – Alex Dec 17 '12 at 16:06
  • I don't believe there is a tool. You need to log your database as it's being used to do what you want. – Kuberchaun Dec 17 '12 at 16:39