Help with query

Help with query

Can someone please help convert this query from Firebird to Postgres?
I have a Cisco 3750G switch-stack which is not showing all ports in SPM, and this query fixed it (prior to migrating to Postgres).
 
update "SPMInputConfig" set "SNMP_SCAN_TYPE"=3 where SWITCHNAME='s-agd-n200j-1'