[gdal-dev] how to export all the definitions of the relationships present in a FileGDB?

[Jan Heckman]

I seem to remember that the n:m relationships can be retrieved as a table.
Look in the TOC.
1:n relationships are not stored in GDB as a table, but as a simple foreign
key relationship as far as I remember.
If you were import an n:m relationship(table) into say postgresql,
you would then have to add the needed (primary and foreign key) constraints
manually or programmatically.
With json, I have no clue how to make the relationship table(s) operational
again. Not quite my turf.
Hope this puts you in the right direction,
Jan

On Sun, Feb 19, 2023 at 1:06 PM Totò Fiandaca <pigrecoinfinito at gmail.com>
wrote:

> Is it possible to export all the relationship definitions present in a
> FileGDB or a GPKG?
>
> with $ ogrinfo -json autotest/ogr/data/filegdb/Domains.gdb I can extract
> all the domains, but for the relationships?
>
> A thousand thanks
>
> --
> *Ing. Salvatore Fiandaca*
> *mobile*.:+39 327.493.8955
> *m*: *pigrecoinfinito at gmail.com <pigrecoinfinito at gmail.com>*
> *C.F*.: FNDSVT71E29Z103G
> *P.IVA*: 06597870820
> *membro QGIS Italia - http://qgis.it/ <http://qgis.it/>*
> *socio GFOSS.it - *http://gfoss.it/
> *member OSGeo* - *https://www.osgeo.org/member/fiandaca/*
> <https://www.osgeo.org/member/fiandaca/>
> *blog:*
> * https://pigrecoinfinito.com/ <https://pigrecoinfinito.com/> FB: Co-admin
> - https://www.facebook.com/qgis.it/ <https://www.facebook.com/qgis.it/>**
> <https://www.facebook.com/qgis.it/> *
> *TW:  <http://goog_95411464>**https://twitter.com/totofiandaca
> <https://twitter.com/totofiandaca>*
>
> 43°51'0.54"N  10°34'27.62"E - EPSG:4326
>
> “Se la conoscenza deve essere aperta a tutti,
> perchè mai limitarne l’accesso?”
> R. Stallman
>
> Questo documento, allegati inclusi, contiene informazioni di proprietà di
> FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario
> in relazione alle finalità per le quali è stato ricevuto. E' vietata
> qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso
> di FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega
> di informare tempestivamente il mittente e distruggere la copia in proprio
> possesso.
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230219/1bfa1380/attachment.htm>