Home > mailing lists

Re: Return only non-null columns - Mailing list pgsql-general

From	Pavel Stehule
Subject	Re: Return only non-null columns
Date	November 13, 2013 16:01:02
Msg-id	CAFj8pRDmTKMac9vspQ0GPEHB-zmSMMcSG+htTuh8GPmFX+1WRw@mail.gmail.com Whole thread Raw
In response to	Return only non-null columns (Dorian Hoxha <dorian.hoxha@gmail.com>)
List	pgsql-general

Hello

2013/11/13 Dorian Hoxha <dorian.hoxha@gmail.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

From: Dorian Hoxha
Date: 13 November 2013, 15:58:25
Subject: Return only non-null columns

From: Torsten Förtsch
Date: 13 November 2013, 16:30:16
Subject: Re: Partitioned table question