> Hi, > I may be wrong but: > Enabling query logging (in the options dialog) will only log the SQL > pgAdmin III sends to the server, it will not capture the query for a > selected process > in the server status dialog. > If you want something like the trace in MS SQL server Lightning Admin > has something similar: > http://www.amsoftwaredesign.com/onlinehelp/pgla/server_status.htm > You can select the process ID you want, then check the Capture selected > rows query option and all the queries for that process that become > visible will be > logged to a memo control, you can then copy the captured queries to > where ever you like.
Out of curiosity, how does that work? I mean, how does it pick up when a new query has been issued? Do you use some server-proc to tail the logfile or such? //Magnus ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
