[postgis-users] Relationships

[strk at refractions.net]

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: ezequias at hotmail.com 


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