Ticket #2662 (closed patch: fixed)
[Patch] custom query in postgres provider
| Reported by: | brushtyler | Owned by: | nobody |
|---|---|---|---|
| Priority: | minor: annoyance | Milestone: | Version 1.5.0 |
| Component: | Data Provider | Version: | Trunk |
| Keywords: | custom query, postgres | Cc: | |
| Platform Version: | Platform: | All | |
| Must Fix for Release: | No | Awaiting user input: | no |
Description
The patch permit you to load a postgres layer using a custom query, like SELECT * FROM tbl1 JOIN tbl2 ON tbl1.gid = tbl2.id WHERE tbl1.gid > 15 LIMIT 10 OFFSET 15 .
The new layer have only select capabilities.
The only limit is that no columns with the same name must be in the result.
Attachments
-
patch.diff
(43.4 KB) - added by brushtyler
3 years ago.
- patch
-
query.diff
(51.0 KB) - added by jef
3 years ago.
- modified patch (some additions/cleanups; eg. allow subset strings)
Change History
Note: See
TracTickets for help on using
tickets.
