Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/#!/StackGIS/status/567274937455763457
Formatted the question.
Source Link
edit approved Jan 27, 2015 at 14:54
Germán Carrillo
edit approved Jan 27, 2015 at 14:54
Germán Carrillo
  • 37k
  • 5
  • 125
  • 180

Visualising a raster postgrePostgreSQL table data in qgisQGIS

I have imported a raster tif image into postgre.. raster2pgsql -s 32643 -I -M filepath.tif -F -t 100x100 public.databassename > filepath.sqlPostgreSQL with this command:

raster2pgsql -s 32643 -I -M filepath.tif -F -t 100x100 public.databassename > filepath.sql

And imported the output sqlSQL file inside the postgrePostgreSQL database psql -U postgres -d databasename -f pathfile.sql running this:

psql -U postgres -d databasename -f filepath.sql

Now afterAfter connecting to this database in QGIS, I am not able to visualise the tif image...due due to missing geometry content. Please help me out to visualise the tif raster imagery in qgis windowQGIS.

Visualising raster postgre table data in qgis

I have imported a raster tif image into postgre.. raster2pgsql -s 32643 -I -M filepath.tif -F -t 100x100 public.databassename > filepath.sql

And imported the output sql file inside the postgre database psql -U postgres -d databasename -f pathfile.sql

Now after connecting this database in QGIS, I am not able to visualise the tif image...due to missing geometry content. Please help me out to visualise the tif raster imagery in qgis window.

Visualising a raster PostgreSQL table in QGIS

I have imported a raster tif image into PostgreSQL with this command:

raster2pgsql -s 32643 -I -M filepath.tif -F -t 100x100 public.databassename > filepath.sql

And imported the output SQL file inside the PostgreSQL database running this:

psql -U postgres -d databasename -f filepath.sql

After connecting to this database in QGIS, I am not able to visualise the tif image due to missing geometry content. Please help me out to visualise the tif raster imagery in QGIS.

Source Link
Adarsh L
Adarsh L
  • 321
  • 3
  • 10

Visualising raster postgre table data in qgis

I have imported a raster tif image into postgre.. raster2pgsql -s 32643 -I -M filepath.tif -F -t 100x100 public.databassename > filepath.sql

And imported the output sql file inside the postgre database psql -U postgres -d databasename -f pathfile.sql

Now after connecting this database in QGIS, I am not able to visualise the tif image...due to missing geometry content. Please help me out to visualise the tif raster imagery in qgis window.