Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables
| От | Dan Shoubridge | 
|---|---|
| Тема | Feature Request for Debugging SQL in PGAdmin3 when SQL contains variables | 
| Дата | |
| Msg-id | 000701cb8587$d8aa26e0$89fe74a0$@autovhc.co.uk обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: Feature Request for Debugging SQL in PGAdmin3
 when SQL contains variables
            		
            		 | 
		
| Список | pgadmin-support | 
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
В списке pgadmin-support по дате отправления: