Re: pg_dump and quoted identifiers

Tom Lane schrieb am 15.12.2016 um 16:20:
>> Still doesn't work:
>> -bash-4.1$ pg_dump -d postgres -t "\"Statuses\""
>> pg_dump: no matching tables were found
>
> Hmm. It might shed some light if you put "echo" in front of that
> to see what gets printed:
>
> $ echo pg_dump -d postgres -t "\"Statuses\""
> pg_dump -d postgres -t "Statuses"

Same here:

-bash-4.1$ echo pg_dump -d postgres -t "\"Statuses\""
pg_dump -d postgres -t "Statuses"

> Also, when having strange issues, I've found the combo
>
> echo <original command> | od -tx1 -tc
>
> very useful, this help rule out potential fancy quotes pointed previously

-bash-4.1$ echo pg_dump -d postgres -t "\"Statuses\"" | od -tx1 -tc
0000000 70 67 5f 64 75 6d 70 20 2d 64 20 70 6f 73 74 67
p g _ d u m p - d p o s t g
0000020 72 65 73 20 2d 74 20 22 53 74 61 74 75 73 65 73
r e s - t " S t a t u s e s
0000040 22 0a
" \n
0000042