sqlserver2pgsql icon indicating copy to clipboard operation
sqlserver2pgsql copied to clipboard

WITH statements are not removed

Open SebastianZ opened this issue 11 months ago • 0 comments

In some MSSQL views I have WITH (NOLOCK) statements after the table names.

E.g. the SELECTs look something like this:

SELECT *
FROM mytable WITH (NOLOCK)

Such WITH statements should be removed when generating the PostgreSQL schemas for views, triggers, and stored procedures.

Sebastian

SebastianZ avatar Mar 05 '24 06:03 SebastianZ