Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with VIEW

Issue 5245: PostgreSQL doesn't support views with nested table columns

Revise your code to replace the nested table with another solution.

Issue 5583: PostgreSQL doesn't support constraints for view

Perform a manual conversion.

Issue 5321: PostgreSQL doesn't support the object view

Perform a manual conversion.

Issue 5077: PostgreSQL doesn't support the PIVOT clause for the SELECT statement

You can use a stored procedure to prepare data, and then return the data with a view.

Issue 5320: PostgreSQL doesn't support the view with invalid status

Perform a manual conversion.

Issue 5322: PostgreSQL doesn't support the typed view

Perform a manual conversion.

Issue 5075: PostgreSQL doesn't support VIEW with the READ ONLY option

Create the view without this option instead.