Re: "Compact" and "complete" SQL

On Mon, May 10, 2010 at 3:20 PM, Erwin Brandstetter
<brandstetter@falter.at> wrote:
> On 07.05.2010 21:21, dpage@pgadmin.org wrote:
>>
>> Sorry - missed that. I generally prefer to only include SQL DDL for
>> things that are non-default.
>
> I generally agree. I see the "complete" variant as an option. The "compact"
> (non-default SQL DDL) version is what would make my work easier.
> However, at the time being we have a mixture. How would you define
> "non-default"?

Anything where explicit DDL is required to recreate the object as it
is. If the DDL is redundant (ie. it tries to set the value we get if
we don't use it at all), then it should be omitted.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company