Re: [HACKERS] Database names with spaces

Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Looks like a bug.  Added to TODO list.

>> I see a todo item
>> * Views with spaces in view name fail when referenced
>> 
>> I have another one for you:
>> * Databases with spaces in name fail to be created and destroyed despite
>> responses to the contrary.

IIRC, createdb and destroydb use "cp -r" and "rm -r" respectively.
Lack of careful quoting in the system calls is probably what's
causing the problem here.

However, I wonder if it wouldn't be a better idea to forbid funny
characters in things that will become Unix filenames.  In particular,
something like CREATE DATABASE "../../../something" could have real
bad consequences...
        regards, tom lane