On Mon, Apr 10, 2017 at 10:51 PM, Osahon Oduware <osahon....@gmail.com> wrote: > 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?
You probably want to post this to a PostGIS mailing list, rather than a PostgreSQL mailing list, since this question is PostGIS-specific. Probably, you want a list for user questions, rather than a list like this one which is for development of the product itself. I think this may be the right one: https://lists.osgeo.org/mailman/listinfo/postgis-users -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers