Re: Bug: psql misquotes constraints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug: psql misquotes constraints
Date
Msg-id 3375.1089597588@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug: psql misquotes constraints  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Bug: psql misquotes constraints  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> It should be done, otherwise you cannot copy and paste foreign key 
> creation code from the psql output :)

Since when was that a design goal for psql's \d output?  We had better
revert the entire pretty-printing patch if you expect this sort of thing
to work reliably.  I thought the point of \d formatting was to be
readable, not to be technically the exact same SQL you'd need to enter.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Removing initlocation
Next
From: "Scott Marlowe"
Date:
Subject: Re: patch for allowing multiple -t options to pg_dump