Table whose name has Capital letters

Поиск
Список
Период
Сортировка
От Gabriel Fernandez
Тема Table whose name has Capital letters
Дата
Msg-id 3A1E4DA7.F1C6BA96@unica.edu
обсуждение исходный текст
Ответы SV: Table whose name has Capital letters  ("Jarmo Paavilainen" <netletter@comder.com>)
Список pgsql-general
Hi ,

I have created a table with the name 'Nov2000' and now it is impossible to
access it, because psql is always searching for the table 'nov2000'.

The only solution I have found is to manually modify the pg_class table and
the name of the physical file associated to the table.

Have I done something wrong or is it a bug ?  I mean, it seems psql is
alwyas converting the query string to lowercase, but it doesn't when you
create a table, a index or a sequence.

I'm running  6.5.3 PostgreSQL on a Linux RedHat 6.0 machine.

Thanks,

Gabi :-)


В списке pgsql-general по дате отправления:

Предыдущее
От: j.logsdon@lancaster.ac.uk
Дата:
Сообщение: Pivotal system
Следующее
От: Claudio Jose Zanardi Grillo
Дата:
Сообщение: Re: pg_dump:cannot find function for trigger