Geography Reference
In-Depth Information
Figure 77: Creating a New View
Give the view a name—I named mine ukcitys_wgs—and set the correct user for your
database login.
Switch to the
Definition
tab and enter the following SQL:
SELECT ukcitys.gid, ukcitys.number, ukcitys.name, ukcitys.admin_name,
st_transform(ukcitys.geometry, 4326) AS geometry FROM ukcitys;
Figure 78: Setting the Database Login
