Opened 3 years ago

Closed 3 years ago

#5011 closed defect (invalid)

raster2pgsql lowers schema and table names

Reported by: frafra Owned by: robe
Priority: medium Milestone: PostGIS 3.1.5
Component: raster Version: 3.1.x
Keywords: Cc:

Description

When I load into a schema called "MySchema" (which I previosly created, raster2pgsql transform that into "myschema", which does not exist, so psql cannot find it.

The same problem happens for table names.

Change History (3)

comment:2 by robe, 3 years ago

Component: postgisraster
Owner: changed from pramsey to robe

comment:3 by robe, 3 years ago

Resolution: invalid
Status: newclosed

frafra,

This looks to be intentional behavior.

Have you tried with the -q switch. that should give you the behavior you are looking for. As noted in that bit of code you highlighted, the lowercasing is only done if quote identify is false.

  -q  Wrap PostgreSQL identifiers in quotes.

I'm going to mark this as invalid. If using -q doesn't work, feel free to reopen.

Note: See TracTickets for help on using tickets.