From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PostGIS Out-DB Raster Not Behaving As Expected |
Date: | 2017-04-11 13:56:00 |
Message-ID: | CA+TgmoaPdw73bdVKpo3SSJxv2d0zdsyC=ZhXW8h9Mf4nwu-8Vw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Apr 10, 2017 at 10:51 PM, Osahon Oduware <osahon(dot)gis(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Osahon Oduware | 2017-04-11 14:00:04 | Re: PostGIS Out-DB Raster Not Behaving As Expected |
Previous Message | Robert Haas | 2017-04-11 13:53:55 | Re: SUBSCRIPTIONS and pg_upgrade |