Postgres Pro
Downloads
Home   >   mailing lists

Thread: Return only non-null columns

Return only non-null columns

From
Dorian Hoxha
Date:
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

Re: Return only non-null columns

From
Pavel Stehule
Date:
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