Re: Return only non-null columns

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Return only non-null columns
Date: 2013-11-13 13:00:16
Message-ID: CAFj8pRDmTKMac9vspQ0GPEHB-zmSMMcSG+htTuh8GPmFX+1WRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

2013/11/13 Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com>

> Is it possible to:
>
> SELECT * FROM table
>
> But to return only non-null columns ?
>

no, it is not possible

Regards

Pavel Stehule

> Since i use psycopg2 with DictCursor (a hashtable) it's better for me when
> i don't have the column that to have it as NULL.
>
> Thanks
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2013-11-13 13:26:39 Re: Partitioned table question
Previous Message Dorian Hoxha 2013-11-13 12:57:49 Return only non-null columns