On Mon, 2012-12-03 at 21:53 +1100, Evan Martin wrote: > Is there any way to get the full query text for a given process in the > Server Status window? The Query column shows the start of it, so I > presume pgAdmin has the whole thing, but is not showing it. If it's not > currently possible please add it! Something like a "copy query to > clipboard" context menu option or, even better, "open query in new query > window" (which would automatically connect to the same database as well). >
The latter already exists: third button in the toolbar (starting from the left). But remember that pgAdmin only gets what PostgreSQL gives it. What I mean is that PostgreSQL truncates the query to the 1024 first characters in old releases. In more recent releases (8.4 I think, but I may be wrong), you have the track_activity_query_size GUC to change the maximum size of a query. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
