Skip to main content


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

Raúl Nanclares 🍜 reshared this.

This website uses cookies to recognize revisiting and logged in users. You accept the usage of these cookies by continue browsing this website.