Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql \dv+ shows view size as 0 bytes

psql \dv+ shows view size as 0 bytes

From
Peter Eisentraut
Date:
\dv+ shows the size of views as "0 bytes".  This doesn't make any sense;
I think it should show null.  Maybe this is even the fault of the
backend functions for returning a number to display in the first place.

Re: psql \dv+ shows view size as 0 bytes

From
Thom Brown
Date:
On 4 June 2013 16:54, Peter Eisentraut <peter_e@gmx.net> wrote:
> \dv+ shows the size of views as "0 bytes".  This doesn't make any sense;
> I think it should show null.  Maybe this is even the fault of the
> backend functions for returning a number to display in the first place.

It doesn't sound useful whether it's 0 or NULL in that output.  Why
have the column in the first place when it can't have a value?  Is it
somehow required for inclusion in the output of \d+ ?

--
Thom

Re: psql \dv+ shows view size as 0 bytes

From
Peter Eisentraut
Date:
On 6/4/13 12:08 PM, Thom Brown wrote:
> It doesn't sound useful whether it's 0 or NULL in that output.  Why
> have the column in the first place when it can't have a value?  Is it
> somehow required for inclusion in the output of \d+ ?

\dv is just a special case of \dvti...