Relationships

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Relationships

Ezequias Rodrigues da Rocha
Hello all,
 
I would like to know how the relationships are done in PostGIS.
 
I have one shapefile that I imagine that will be loaded on PostGIS (using shp2pg)  but I don't know how to add a dbf table that isn't a shapefile but will be related to the shapefile I just loaded.
 
I would like to know:
 
All the shapefile (GEO) files will be loaded on a postgreSQL database ?
The dbf file will be loaded on the postgreSQL ?
 
Best regards
Ezequias
 
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
                                * www.recife.pe.gov.br
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
  MSN Messenger: [hidden email] 
Add FUN to your email - CLICK HERE!
_______________________________________________
postgis-users mailing list
[hidden email]
http://postgis.refractions.net/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Relationships

strk
Refer to any SQL manual, relationships are customly defined
at query time (check for JOIN).
Foreign-keys integrity constraints can be added as all others
(check for CONSTRAINT).

--strk;

On Mon, May 30, 2005 at 09:50:07AM -0300, Ezequias Rodrigues da Rocha wrote:

> Hello all,
>
> I would like to know how the relationships are done in PostGIS.
>
> I have one shapefile that I imagine that will be loaded on PostGIS (using
> shp2pg)  but I don't know how to add a dbf table that isn't a shapefile but
> will be related to the shapefile I just loaded.
>
> I would like to know:
>
> All the shapefile (GEO) files will be loaded on a postgreSQL database ?
> The dbf file will be loaded on the postgreSQL ?
>
> Best regards
> Ezequias
>
>  
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>                                   Atenciosamente (Sincerely)
>                         Ezequias Rodrigues da Rocha
>                                 * www.recife.pe.gov.br
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> A pior das democracias ainda é melhor do que a melhor das ditaduras
> The worst of democracies is still better than the better of dictatorships
>   MSN Messenger: [hidden email]


> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[hidden email]
http://postgis.refractions.net/mailman/listinfo/postgis-users