Repository navigation
Collections from materialized views #170
Answered
by
vincentsarago
joconnor-ecaa
asked this question in
Q&A
|
Hi all, thank you for the excellent work. I'd like to know if I can serve vector tiles from a materialized view in postgres. I have tipg running successfully against multiple tables in my DB, but it does not pick up any views. Is this something I can fix with configuration? |
Answered by
vincentsarago
Mar 12, 2024
Replies: 1 comment
|
Materialized view should be available if they are in the schema defined with The we do tests this with https://github.com/developmentseed/tipg/blob/main/tests/fixtures/my_data.sql#L18-L19 also make sure that the view as a geometry column declared |
0 replies
Answer selected by
joconnor-ecaa
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Materialized view should be available if they are in the schema defined with
TIPG_DB_SCHEMAenv (default topublic)The
catalogcode is over https://github.com/developmentseed/tipg/blob/main/tipg/sql/dbcatalog.sql#L251-L260 if you want more hints.we do tests this with https://github.com/developmentseed/tipg/blob/main/tests/fixtures/my_data.sql#L18-L19
also make sure that the view as a geometry column declared