Le 16/11/2010 13:14, Dan Shoubridge a écrit : > 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... >
And? I don't see why pgscript can't do that. The example you give is certainly doable with pgscript. > 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 > > -- Guillaume http://www.postgresql.fr http://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
