Can a single cell of a table component include line breaks ?

[mgmgh]

Hi,
I have an array column from a table and I would like to have separated lines for each element inside the cells.
I've tried with a "\n" and a "
" tag but it does not work.
Tried also with markdown, with " * " marker.
The result remains on a single line :-(

[mgmgh]

Sorry, I forgot to quote correctly, the original sentence was:
I've tried with a "\n" and a "<br/>" tag but it does not work.

[lovasoa]

Okay, I think I understand:

• You have a PostgreSQL table with a column of type TEXT[] (an array of strings), and
• you want to display this data in a SQLPage table component,
• with each element of the array displayed on a new line within the table cell.

Is that correct ?

The key to making this work is using markdown, and remembering that in markdown, paragraphs of text are delimited by two \n characters, not one.

CREATE TABLE IF NOT EXISTS my_table (
  name VARCHAR(255) PRIMARY KEY,
  tags TEXT[]
);

INSERT INTO my_table (name, tags) VALUES
  ('Item 1', ARRAY['tag1', 'tag2', 'tag3']),
  ('Item 2', ARRAY['tag4', 'tag5']),
  ('Item 3', ARRAY['tag6', 'tag7', 'tag8', 'tag9'])
ON CONFLICT (name) DO NOTHING;

select 'table' AS component, 'tags' as markdown;
SELECT
  name,
  (
    SELECT string_agg(tag, E'\n\n')
    FROM unnest(my_table.tags) AS tag
  ) AS tags
FROM my_table;

[mgmgh]

Yes! Perfect ! Application can go to production now ;-)
FYI, It's just a small interface for "crud" on 4 new tables in an existing pg database, with some display coming from views. With no more support on the existing backoffice (symfony) , I decided to use sqlpage for future interface.