| From: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PostGIS Out-DB Raster Not Behaving As Expected |
| Date: | 2017-04-11 02:42:14 |
| Message-ID: | CAGpiUSi4WiRpFit7nAxz5GDNZM6KdgYakPfRMr8W_5xgB3ca3g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
I created an out-db raster using the following syntax:
raster2pgsql -s {srid} -c -R -I -C -F -t auto {absolute_file_path}
public.{table} | psql -h {host} -p {port} -d {database} -U {user}
The table was created successfully. I wanted to confirm that the actual
file is being read from the location in the filesystem by performing the
following steps:
1) I moved the raster file to a different location.
2) I opened QGIS and attempted to load the raster from PostGIS table.
I was surprised that QGIS could load the file. *How is this possible when
the actual raster data is not stored in the database table?*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Osahon Oduware | 2017-04-11 03:34:14 | PostGIS Raster - Loading MrSID format |
| Previous Message | Adrian Klaver | 2017-04-11 00:02:09 | Re: Unable to connect to Postgresql |