[Qgis-user] Raster postGIS problema visualizar en QGIS

[Juan Miguel Requena]

Hello Michael, thank you very much for your reply. My problem has been
solved. Indeed, I was trying to import the postGIS raster from the wrong
way, i.e., 'Add PostGIS layer', and when I load it from DB Manager plugin
there is no problem, it was very easy but it was my first time. Thank you
again.

Best regards.

Juanmi.

2014-11-13 4:35 GMT+01:00 Michael Treglia <mtreglia at gmail.com>:

> Hi Juan,
>
> To display a PostGIS Raster in QGIS, I think you need to use the Database
> Manager plugin ("DB Manager"). If you have it installed/activated, you
> would access it from the "Database" tab in the menu bar at top.   (I'm on
> QGIS 2.6 and 2.4, but I'd imagine its the same for 2.0).
>
> Is that what you're using to open the PostGIS Raster? Or were you trying
> to just use the normal "Add PostGIS layer" method?
>
> If that's not it, try to give more details of the steps youre taking to
> access the PostGIS layer in QGIS.
>
> Hope that helps,
> Mike
>
> On Wed, Nov 12, 2014 at 3:45 PM, Juan Miguel Requena <
> juanmimullor at gmail.com> wrote:
>
>> Hello Alexandre, sorry.
>>
>> I have used the postGIS command 'raster2pgsql' to import a geotiff file
>> into a postgres data base.The process was successfully finished. Both
>> columns 'rid' and 'rast' were successfully created but when I connect QGIS
>> 2.0 to the data base and load the table, the software is unable to
>> recognize the data type and the geometry type, so that I can not visualize
>> the file and the attribute table has not the rast column.
>>
>> Thank you in advance for your help
>>
>> Juanmi
>>
>> El 12 de noviembre de 2014, 20:51, Alexandre Neto <senhor.neto at gmail.com>
>> escribió:
>>
>> Hello Juan,  can I ask you to write your question in English?
>>>
>>> Thanks,
>>>
>>> Alexandre Neto
>>> Em 12/11/2014 16:25, "Juan Miguel Requena" <juanmimullor at gmail.com>
>>> escreveu:
>>>
>>>> Hola, estoy utilizando el comando raster2pgsql de postGIS para importar
>>>> un archivo geotif a una base de datos (postgresql). Todo el proceso lo
>>>> ejecuta correctamente. Crea los campos 'rid' y 'rast' bien. Pero al
>>>> conectarme a la base de datos con QGIS, la tabla postgres correspondiente
>>>> viene como 'Tipo de dato' : Nada y 'Tipo espacial' : Ninguna geometría.
>>>> Cuando añado el archivo y visualizo la tabla de atributos solo existe el
>>>> campo 'rid' pero no el 'rast'.
>>>>
>>>> Alguien puede echarme un mano, muchas gracias por adelantado.
>>>>
>>>> Juanmi.
>>>>
>>>> _______________________________________________
>>>> Qgis-user mailing list
>>>> Qgis-user at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141113/d424d237/attachment.html>