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'


        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial





                            Related Products