sp_executesql allows typed parameters in dynamic SQL. In PostgreSQL use EXECUTE ... USING in PL/pgSQL or format() with %I for identifiers and %L for literals.
Safe pattern in PostgreSQL
EXECUTE format('SELECT * FROM %I', table_name);SQL Server EXEC and sp_executesql become EXECUTE format() or PL/pgSQL with quote_literal in PostgreSQL.
sp_executesql allows typed parameters in dynamic SQL. In PostgreSQL use EXECUTE ... USING in PL/pgSQL or format() with %I for identifiers and %L for literals.
EXECUTE format('SELECT * FROM %I', table_name);Dynamic SQL is an injection vector if converted poorly. Review every EXEC in the project risk map.