how to exclude columns in select view?

[zapirkon]

I can't find a plugin for this, and I want it because loading a postgres table through select hyperlink on the left is extremely slow for tables having huge text or json columns.

(edit) or loading table with lot of colums is slow

Selecting those columns manually in SQL command menu by listing them seems to be much faster (the browser becomes laggy, but not slow to load the rows).

Edit row view is fine and fast.

Setting text length to zero or empty is with identical performance (slow) when going through the select view.

I would think this could be done with a plugin that can alter select * with filtered column list (help needed in that case)

[vrana]

Please provide a reproducible example. I work with really big tables and Adminer is not slow with them.

Adminer cuts long texts in select by default.

[zapirkon]

Here are two rough samples with 200 columns that render slowly.

lot_of_columns.zip

At first, I thought the issue was due to some json values being 1MB, but after excluding those, I saw same slowness, even if those columns contained 1 character value each (loading 50mb html for 200x50=10k cells) so maybe there is no way around for this kind of tables

lot_of_columns_text_small.zip