A geometry column is only a type like integer or text for postgresql. See http://postgis.refractions.net/documentation/manual-1.3/ch04.html#id2572181
-----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Nenad Milasinovic Gesendet: Montag, 13. Juli 2009 16:43 An: [email protected] Betreff: Re: [postgis-users] PostGIS-PostgreSQL Thanks Chris, However maybe better question will be can spatial and non-spatial data be saved in one PostgreSQL table? Precisely, is it possible to have table with some spatial columns (geometry columns) and with some ordinary columns (non-spatial) and is it good practice? >From your answer i can conclude that it is possible to have table without >spatial data that refers to some spatial table through foreign key? Chris Hermansen wrote: > > This is a part of good database design. Street name, which can be > changed, is only stored in one location. > > This is part of "normalization". This practice relates to any / all > databases ------Original Message------ > From: Nenad Milasinovic > Sender: [email protected] > To: [email protected] > ReplyTo: PostGIS Users Discussion > Subject: [postgis-users] PostGIS-PostgreSQL > Sent: Jul 13, 2009 06:18 > > Hello, > > I have some questions relating to PostGIS and PostgreSQL. > I am interested how GEO-data from PostGIS are connected to data in > PostgreSQL. > Say that we have vector layer of all city streets in PostGIS table, with > some street attributes (e.g. street name). > Say also that we have all data about locations in PostgreSQL table. That > data contains information about location street also. > What i want to accomplish is that when user change street name is > PostGIS table, that street name should automatically be changed in > all locations which belongs to that street. I am interested is there any > connection between tables in PostGIS and PostgreSQL > that could automatize this process, or i need to update all locations > with new street data by myself. > > Thanks. > > > > > -- > Nenad Milasinovic > Software Development and Testing > > --- > > "ZESIUM mobile" d.o.o. > Valentina Vodnika 8/9 > 21000 Novi Sad > Serbia > Tel: +381 (0)21 472 15 48 > Fax: +381 (0)21 472 15 49 > Mob: +381 (0)61 231 41 20 > E-mail: [email protected] > > _______________________________________________ > postgis-users mailing list [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > Chris Hermansen [email protected] > tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625 > Timberline Natural Resource Group · www.timberline.ca > 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5 > _______________________________________________ > postgis-users mailing list [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://www.nabble.com/PostGIS-PostgreSQL-tp24461543p24463072.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
