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'