TatukGIS menu

Q&A - Question

PostgreSQL/Postgis direct connection

FabD asked on May 23, 2019, keyword: Developer Kernel
I'm trying the .NET SDK (trial version). I need to create some layers taking the data from a PostgreSQL/PostGIS database.
Now I can create the layers connecting to the database through ODBC using the TGIS_LayerSqlPgisAdo class. I would like to know if there is a way to connect directly to the database without using the ODBC interface.
I've read that I can also use the OLEDB interface. In your experience, what's the best choice in terms of performance?
Artur Redzko (TatukGIS) replied September 12, 2016
The best provider is LIBPQ. To use it with the NDK, make a .ttkls file as described :

      [TatukGIS Layer]
      Features=table/view name; if provided will replace standard features table
      Libpq=LIBPQ connection string
      GeometryFieldCast=Text|Binary|EWKB|Native - default is Binary if parameter omitted
      GeometryRelationships=Server|Client - default is Client if parameter omitted
      GeometryColumn=name of geometry column if there are many
      IndexColumn=unique ID column name for the UID (must be numeric type)
      Sequence=sequence name used to retrieve unique shape uid
      RowsetSize=number of rows to fetch in a batch from a cursor (default 0, recommended 2000)

e.g. :

      [TatukGIS Layer]
      Libpq=host=db port=5432 dbname=gis user=p password=u client_encoding=WIN1250

then copy libpq dll-s from postgres installation into your application .exe directory and open the layer with the .ttkls file in the viewer.
FabD replied September 13, 2016
Thank you very much, I've tried with LIBPQ and it works.
Only a little clarification: copying libpq.dll is not enough because it has some dependencies. You must also copy all dependencies (some other DLLs that one can found using a Dependency Walker)
Artur Redzko (TatukGIS) replied September 13, 2016
Yes,these are : libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, ssleay32.dll
AKNLEO replied May 23, 2019
Hello, I tried this but it does not work

  [TatukGIS Layer]
Libpq= 9.5 port=5432 dbname=rfu user=postgres password=pgrfu client_encoding=WIN1250

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.
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.