| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Vijay Garg <vijay(dot)g(at)sabudh(dot)org> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org, Sukhjit Singh <sukhjit(at)sabudh(dot)org>, sukhjit sehra <sukhjitsehra(at)gmail(dot)com> |
| Subject: | Re: Problem in Storing Satellite imagey(Geotiff file) |
| Date: | 2021-10-04 15:12:45 |
| Message-ID: | 4fc6204d-b1ff-24b1-5f51-d569077e6440@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/4/21 2:19 AM, Vijay Garg wrote:
> Hi Adrian,
>
> I am using postgres 13.4 version & postgis 3.1 version. I have used the
> following command to upload the data.
>
> raster2pgsql -I -C -s 4326 C:\Users\Admin\Desktop\dem.tif raster.dem |
> psql -U postgres -d India -h localhost -p 5432
>
> I am able to upload dem file in postgres but I am not able to check any
> table.
The image shows that you can check(select from) the table. What you are
seeing is the image data stored in a binary format. You will not see the
actual image. To get that see this section of PostGIS docs:
https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Applications
>
> I am attaching the screenshot in this email.
>
> image.png
>
> --
> *Thanks & Regards*
> Vijay Garg
> Contact Number: 6283101848
> Sabudh Foundation
> New Delhi
>
>
>
>
> On Sun, Oct 3, 2021 at 2:18 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2021-10-04 15:43:42 | Testing of a fast method to bulk insert a Pandas DataFrame into Postgres |
| Previous Message | Ron | 2021-10-04 14:14:10 | Re: Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4) |