On Wed, Mar 7, 2012 at 6:34 AM, David Johnston <pol...@yahoo.com> wrote: > I know there is currently work ongoing regarding normalizing SQL statements > for logging purposes but has anyone considered given us the ability to name > our statements. > > SELECT .... > FROM ... > WHERE .... > NAMEAS 'Name to track by' > > If a query lacks a name the algorithm generated normalized form would be used > instead but otherwise all queries with the same name would be treated as > being the same for statistics purposes. > > I'm sure there is more to it but the idea of letting the user name their > queries, and thus have something to actually link the logs and the source > code directly, has merit and at the least provides a workaround to an > algorithmic routine. >
You could place a 'C style' comment at the beginning of the statement. Ex: /* MagicQuery-001 */ select awsome_stuff from coolness_table where user_id=?; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
