Is there way to display all column of a sql query result in table or datagrid or ascii table ?

[heejit]

is it possible ?

[lovasoa]

Yes, just use the table component!

[heejit]

columns are not fixed

[heejit]

this works ->

select 'table' as component;

with tb1 as
(
   select to_jsonb(t) as jdata from schema.table as t
)
SELECT 
    'dynamic' AS component,
    jdata as  properties
FROM 
    tb1;

[lovasoa]

Why not just:

select * from schema.table;

?

[heejit]

yes that also working thanks.

[lovasoa]