Re: [BUGS] BUG #4337: psql -c case insensitive
Tom Lane wrote: > "none" <[EMAIL PROTECTED]> writes: >> I'm programming an application that uses psql (...) -c "ALTER DATABASE >> \"MyBase\" RENAME TO \"MyBase2\" and it doesn't work because it looks for a >> "mybase" database name. > > Works for me. I speculate that your scripting language is losing the > embedded double-quotes somewhere before psql gets them. I don't know > much about Windows scripting so it's hard to say more than that; but > an extra interpretation pass over the command string would probably > cause such a problem. Most likely you're bit by the completely insane rules of quoting in the windows commandshell. See for example the comments around it in src/port.h in the PostgreSQL distribution. //Magnus -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] psql's copy binary to stdout
I found that 7.4 psql's 'copy binary to stdout' doesn't work. While 8.3's work fine. I saw there were couple of discussions regarding this back in 2005, but don't know if it was classified as a bug. Is this a known bug in 7.4? Thanks. -- Heeman Lee