Importing Raster to PostGIS?

Asked 6 months ago

Viewed 64 times

I am new to PostGIS - on windows 10. I have managed to install it and have a database with vector data working in QGIS.

I am now trying load raster data. I have edited the PATH to point to Postgres folder.

I can login to my database from a command window but when i type the raster2pgsql command at the hash prompt - nothing happens.

This is an example of the commands;

raster2pgsql -s 3035 g100_06.tif public.c-100 |psql -d CORINE

What am I doing wrong?

PolyGeo♦

54.9k17 gold badges86 silver badges258 bronze badges

asked Feb 11 at 13:51

Aquamarine

1657 bronze badges

3

Edit your question and add the command you are trying with – BERA Feb 11 at 13:52
What do you mean by the hash prompt? Are you logged into the database with psql? Raster2pgsql is a standalone executable and you must launch it directly from the command window. – user30184 Feb 12 at 6:55
To expand on what user30184 said, raster2pgsql is a normal command you run at a command prompt, which then pipes, the | sign, the output ( a bunch of insert statements) to the psql command to do the actual insert. – John Powell Feb 12 at 7:03
oops - silly mistake - I know where to start now - thanks. – Aquamarine Feb 12 at 9:30

add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy