Re: [GENERAL] pg_dump and quoted identifiers

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [GENERAL] pg_dump and quoted identifiers
Дата
Msg-id d62d5443-0e89-a880-ffb5-fcddbddca6d5@aklaver.com
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_dump and quoted identifiers  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
On 12/14/2016 11:37 PM, Thomas Kellerer wrote:
> Adrian Klaver schrieb am 14.12.2016 um 15:32:
>>>> I'm suspicious that you're not actually typing plain-ASCII single and
>>>> double quotes, but some fancy curly quote character.
>>>
>>> Definitely not. I typed this manually on the command line using Putty
>>
>> So you are reaching the Bash shell via Putty on a Windows machine, correct?
>
> Correct.
>
>> So have you tried the answer from the SO question?:
>>
>> "\"Statuses\""
>
> Still doesn't work:
>
>   -bash-4.1$ pg_dump -d postgres -t "\"Statuses\""
>   pg_dump: no matching tables were found
>
> Must apparently be something strange with the bash on that server.

Have you tried using using something other then Putty to connect to the
machine and/or from a non-Windows machine?

>
> It's not really important, as we never use quoted identifiers where I work anyway (and the above problem is precisely
oneof the reasons). 
>
> I was just curious what the correct solution would be, but apparently there is no single answer and it depends on the
environment.
>
> Thomas
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: [GENERAL] pg_dump and quoted identifiers
Следующее
От: Tom DalPozzo
Дата:
Сообщение: [GENERAL] tuple data size and compression