[gdal-dev] Trouble using TEMPORARY=ON with ogr2ogr

2022-11-30 Thread Daniel Mannarino
Hello! I'm having trouble using the temporary table option of ogr2ogr: https://gdal.org/drivers/vector/pg.html#layer-creation-options Ultimately I am trying to load data from a Shapefile into a temporary table, enrich the rows in the temporary table, and then copy from the temporary table into

Re: [gdal-dev] PostGIS and ogrinfo: not able to view all the tables of a PostGIS schema

2022-11-30 Thread andy
Thank you On Wed, 30 Nov 2022 at 13:53, Even Rouault wrote: > try adding -oo LIST_ALL_TABLES=YES > Good answer, to stupid question! -- ___ Andrea Borruso website: https://medium.com/tantotanto 38° 7' 48" N, 13° 21' 9" E, EPSG:4326 ___ "cercare e saper

Re: [gdal-dev] PostGIS and ogrinfo: not able to view all the tables of a PostGIS schema

2022-11-30 Thread Even Rouault
try adding -oo LIST_ALL_TABLES=YES cf https://gdal.org/drivers/vector/pg.html#dataset-open-options Le 30/11/2022 à 13:00, andy a écrit : Hi, if I run ogrinfo -ro -so PG:"dbname='arpa_db' host='192.168.xxx.xxx' port='5432' user='postgres' password='' schemas=public" I see 3 tables in

[gdal-dev] PostGIS and ogrinfo: not able to view all the tables of a PostGIS schema

2022-11-30 Thread andy
Hi, if I run ogrinfo -ro -so PG:"dbname='arpa_db' host='192.168.xxx.xxx' port='5432' user='postgres' password='' schemas=public" I see 3 tables in the list. The real list contains 32 tables. If I explore the same schema, with the same credentials, using pgAdmin 4 I see all 32 tables. If I