Re: Bug: psql misquotes constraints

It should be done, otherwise you cannot copy and paste foreign key
creation code from the psql output :)

Chris

Bruce Momjian wrote:

> I can do that for 7.6. Is it worth it? Is it a TODO?
>
>
> ---------------------------------------------------------------------------
>
> Christopher Kings-Lynne wrote:
>
>>>As a result of the constraint output functions being shared between
>>>pg_dump and psql, some of the output is mis-quoted in the display area
>>>for columns including quotes. Notice it's correct in the table Column
>>>list, but the constraint has the escaped versions.
>>
>>It's misquoted because psql DOES NOT share the fmtId function with
>>pg_dump. It simply puts double quotes around it. If you can fix psql
>>so that it is able to link to the fmtId function, then you can easily
>>fix the problem.
>>
>>Chris
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 8: explain analyze is your friend
>>
>
>