raster2pgsql ignores srid, outdb empty

[martinl]

I have imported GeoTIFF (1) to PostGIS as

IN-DB

raster2pgsql -s 5514 -Y dmt.tif ukol_1.dmt | psql pokusnik 2>err

and OUT-DB

raster2pgsql -s 5514 -R `pwd`/dmt.tif ukol_1.dmt_link | psql pokusnik 2>err

Two issues confuses me:

SELECT r_table_schema,r_table_name,srid,out_db FROM raster_columns;
 r_table_schema | r_table_name | srid | out_db 
----------------+--------------+------+--------
 ukol_1         | dmt          |    0 | 
 ukol_1         | dmt_link     |    0 | 

1. srid is 0 even I entered -s 5514 (this code exists in spatial_ref_sys)

2. out_db is empty in both cases

(1) ​http://training.gismentors.eu/geodata/eu-dem/dmt.zip

[robe]

You are reading raster_columns table. That gets populated by constraints.

You need to add the -C to your load to make that populate right.

If you just want to confirm your srid is set do

SELECT ST_SRID(rast)
from dmt LIMIT 1

Please post future questions like this not to our bug tracker, but to users mailing list

​http://lists.osgeo.org/mailman/listinfo/postgis-users

[martinl]

Replying to robe:

You need to add the -C to your load to make that populate right.

oh, it really hidden and confusing. I would expect opposite behaviour, create constraints by default, optionally could be switched off by flag.

Thanks for quick answer. Martin