Sampling Postgres data in QGIS
Let's say you have a large data source and you want to roughly see what data you have, without having to pull and render every little forest path in the world (which could take forever).
You can do this by creating a custom layer and use the `TABLESAMPLE` [1] to retrieve a subset of the data.
[1] https://www.postgresql.org/docs/current/sql-select.html#SQL-FROM
#postgres #qgis
Let's say you have a large data source and you want to roughly see what data you have, without having to pull and render every little forest path in the world (which could take forever).
You can do this by creating a custom layer and use the `TABLESAMPLE` [1] to retrieve a subset of the data.
[1] https://www.postgresql.org/docs/current/sql-select.html#SQL-FROM
#postgres #qgis
SELECT
SELECT SELECT, TABLE, WITH — retrieve rows from a table or view Synopsis [ WITH [ RECURSIVE ] with_query [, …PostgreSQL Documentation
Raúl Nanclares 🍜 reshared this.