From: | Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> |
---|---|
To: | Discuss List Postgres <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | FDW to postGIS Database |
Date: | 2022-03-06 16:36:18 |
Message-ID: | d8e9864972d4b84aa69ad609d4e78aa6@brookhurstdata.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Let say that I have a database named stp. I also have another database
named geo that is a PostGIS database for storing geopolitical and
geospatial data. I want to set up a foreign data wrapper in stp to
connect to geo, so that for each address in stp, I only have to store
the primary key value of the lowest level geo unit, such as a city. I
can always display the city's county, state, country, whatever in views
in stp. I plan to have other databases that need geo data so I want a
single source of truth for geopolitical and geospatial data.
My questions are:
1. Do I have to install PostGIS in stp?....or is it sufficient to
install PostGIS only in geo?
2. Do I need the postgis extension in stp? (I'm thinking yes, but I
don't want to guess.)
3. I want to geocode addresses in stp. Do I need to install any
geocoding software in stp?...or can it be used from geo?
Thanks for your help!
Sue
--
--------------------------------------
Susan E Hurst
Email: susan(dot)hurst(at)brookhurstdata(dot)com
Mobile: 314-486-3261
From | Date | Subject | |
---|---|---|---|
Next Message | Stéphane Klein | 2022-03-06 18:41:44 | Do you know a json_populate_record alternative method to create a ROW with a named field notation? |
Previous Message | Tom Lane | 2022-03-06 16:10:00 | Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal |