Debugging SQL in PGAdmin3 when sql contains variables
- by Mr Shoubs
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.. yay great debugging scenario.
e.g. (please note I am rust and syntax may be incorrect)
declare @x as varchar(10)
set @x = 'abc'
select * from sometable where somefield = @x
I want to do something simular…