Exclude column by default

[ogerardin]

I have a table with a tsvector column which is used for full-text search.

It makes no sense to include this column in the response, so I'd like to know if there's a way to omit a column by default on all queries.

I can always use the select param to list the columns I want to include, but it's awkward because what I really want is to exclude a column. It would be great if I could use something like select=-summary_ts to exclude a column.

[steve-chavez]

The same feature was requested on #1879.

Views don't help here, I think the only way you can do it now is with a function/RPC that takes the col as parameter but doesn't return it.

[ogerardin]

The same feature was requested on #1879.

Views don't help here, I think the only way you can do it now is with a function/RPC that takes the col as parameter but doesn't return it.

Thanks but that would be too complicated, I was looking for a simple solution. I'll be following the other thread you mentioned.