Can't QGIS see GRASS tables in PostGIS??

[thyberio]

Hi all,
I have a GRASS location with driver=pg. When i save a new vector GRASS layer in a PostGIS table, it can't be seen by QGIS through "add postgis layer". In this way i can't see views created from this table too. I noted that the column the_geom doesn't appear in the table. Is that the problem? Don't they have compatibility?
I'm using:
Ubuntu 9.04 - GRASS64 - PostgreSQL 8.3 - PostGIS 1.3.3-3 - QGIS 1.1

Help meeeee!!!!

Thybério Luna - Brazil

[Paragon Corporation-2]

Thybério,

I don't think QGIS relies on the geometry field being called anything in
particular, but I think it only shows a table/view in the list if the
geometry column is registered in the geometry_columns table.

So do a

SELECT * FROM geometry_columns;

And verify that your new vector layer table is listed there.  I'm not too
familiar with GRASS, but it could be its not creating a geometry column at
all and just a regular old PostgreSQL table with no geometry column.  

Leo

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of thyberio
Sent: Saturday, July 04, 2009 11:00 PM
To: postgis-users@...
Subject: [postgis-users] Can't QGIS see GRASS tables in PostGIS??


Hi all,
I have a GRASS location with driver=pg. When i save a new vector GRASS layer
in a PostGIS table, it can't be seen by QGIS through "add postgis layer". In
this way i can't see views created from this table too. I noted that the
column the_geom doesn't appear in the table. Is that the problem? Don't they
have compatibility?
I'm using:
Ubuntu 9.04 - GRASS64 - PostgreSQL 8.3 - PostGIS 1.3.3-3 - QGIS 1.1

Help meeeee!!!!

Thybério Luna - Brazil
--
View this message in context:
http://www.nabble.com/Can%27t-QGIS-see-GRASS-tables-in-PostGIS---tp24339709p
24339709.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[thyberio]

Solved!!!

I changed the way to import shapefiles. Before, i imported into GRASS and saved in PostGIS table. Now i import into PostGIS using shp2pgsql and then i import it to GRASS. How GRASS create a new table, a delete this new table and connect the vector layer with the original table. In this way, GRASS, PostGIS and QGIS can talk themselves. It seems complicated, but woks.

Thanks!!!

Thybério Luna

2009/7/4 thyberio <thyberio@...>


    Hi all,
    I have a GRASS location with driver=pg. When i save a new vector GRASS layer
    in a PostGIS table, it can't be seen by QGIS through "add postgis layer". In
    this way i can't see views created from this table too. I noted that the
    column the_geom doesn't appear in the table. Is that the problem? Don't they
    have compatibility?
    I'm using:
    Ubuntu 9.04 - GRASS64 - PostgreSQL 8.3 - PostGIS 1.3.3-3 - QGIS 1.1

    Help meeeee!!!!

    Thybério Luna - Brazil
    --
    View this message in context: http://www.nabble.com/Can%27t-QGIS-see-GRASS-tables-in-PostGIS---tp24339709p24339709.html
    Sent from the PostGIS - User mailing list archive at Nabble.com.

    _______________________________________________
    postgis-users mailing list
    postgis-users@...
    http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users