Originally from SQL Server background, there is one feature that I am missing and would save developers hours of time.
In SQL Server I could copy sql code out of an application and paste it into SSMS, declare & assign vars that exist in the sql and run - great debugging scenario. e.g. (please note I am rusty and syntax may be incorrect) declare @x as varchar(10) set @x = 'abc' select * from sometable where somefield = @x It would be amazing if simular functionality could be built into in pgadmin3 (NpgSQL uses : instead of @) where I can just drop my sql (params & all) into the query window. I realise you can create pgscript, but it doesn't achieve the above... Currently I have a peice of sql someone has written that has 3 unique varibles in it which are used around 7 times each... I originally posted this question on stack overflow, there doesn't seem to be a (commercial) competitor that does this either: http://stackoverflow.com/questions/2959343/debugging-sql-in-pgadmin3-when-sq l-contains-variables -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
