Home > mailing lists

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

From	Dorian Hoxha
Subject	Return only non-null columns
Date	November 13, 2013 15:58:25
Msg-id	CANsFX05UT+LArSm-45eoFwuhV528M9vVzpVgJ3aMTvx0+dsNXQ@mail.gmail.com Whole thread Raw
Responses	Re: Return only non-null columns
List	pgsql-general

Is it possible to:

SELECT * FROM table

But to return only non-null columns ?

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: Gabriel Sánchez Martínez
Date: 13 November 2013, 15:49:24
Subject: Re: Partitioned table question

From: Pavel Stehule
Date: 13 November 2013, 16:01:02
Subject: Re: Return only non-null columns