> I'm not sure you understood me. Perhaps not, here is what we have:
\c template_db CREATE TABLE "example" ( "col" integer); CREATE DATABASE newdb WITH TEMPLATE template_db UPPERCASE IDENTIFIERS; \c newdb SELECT "col" FROM "example"; > In short, I don't think this suggestion broke your database. I understood that since "example", when copied, would turn into "EXAMPLE" -- but that if it was "Example" it would be copied as "Example". ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
