importccl: IMPORT PGDUMP does not import views

[rytaft]

None of the IMPORT PGDUMP variants import views from the pg_dump file. This seems like something that should be supported, since the syntax for Postgres views is the same as CockroachDB views. If it can't be supported, that should probably be added to the docs as a limitation.

This was found as part of QA for #28158.

[shermanCRL]

It’s possible we’ll get this ‘for free’ if we refactor IMPORT to hand off all DDL to SQL. We’ll close this for now, since we won’t act on this specific issue.

[steve-taylor]

t’s possible we’ll get this ‘for free’ if we refactor IMPORT to hand off all DDL to SQL.

This should also be done for indexes and sequences. The import will fail if there are any expression indexes. Sequences outright fail the import because it expects nextval and setval to prefix quoted sequence names with public.. I had to rip out those DDL statements and manually execute them after the import, which should be automated.