Q&A - Question

Move geometry_columns to a Different Schema

Question
ReaB asked on December 23, 2019, keyword: Developer Kernel
I am using the OpenGisWkt storage type in a PostgreSQL database. How can I "tell" tatukgis that I moved the geometry_columns and the spatial_reference_systems tables from the public schema to the tatuk schema?

Here is the path I am using (FireDAC).
String lPath =
 "Storage=OpenGisWkt\n"
 "Layer=" + lLayerName + "\n"
 "Dialect=POSTGRESQL\n"
 "LoginPrompt=0\n"
 "SERVER=localhost\n"
 "User_Name=postgres\n"
 "Password=myPW\n"
 "Database=amped\n"
 "DriverID=PGx64\n"
 ".ttkls";

Thanks.
Rea
Answers
Artur Redzko (TatukGIS) replied December 21, 2019
Please check if using an alias in lPath works : 
GEOMETRY_COLUMNS=tatuk.GEOMETRY_COLUMNS\n
SPATIAL_REFERENCE_SYSTEMS=tatuk.SPATIAL_REFERENCE_SYSTEMS\n
 
ReaB replied December 23, 2019
Thanks Artur. That works perfectly!
Rea
If you would like to answer the question please Sign In.
*
*
Please review our recent Privacy Policy.
If you have any questions or requests, please contact us.
Rules
The Questions and Answers (Q & A) is intended to provide a means of communication between TatukGIS customers.
 
  1. Licensed users (with active maintenance play) of TatukGIS products may contribute to the Q & A content. Read-only access is available to anyone.
  2. Keep the content positive and professional.
  3. Be courteous to others by posting information when a question or issue asked on the Q & A is answered or resolved by other means (such as with help from TatukGIS technical support). Offer others at least a hint how the posted question was answered or the issue was resolved.
  4. The Q & A is not a replacement for TatukGIS technical support. TatukGIS team may or may not regularly follow or contribute content.