Skip to main content

Return to Answer

added 52 characters in body
Source Link
Radek Postołowicz
Radek Postołowicz
  • 4.9k
  • 2
  • 32
  • 52

Here you areYou can use postgresql json data type (and its related features):

select row_to_json(table_name)->>(row_to_json(table_name)->>'column_name') from table_name;

Here you are:

select row_to_json(table_name)->>(row_to_json(table_name)->>'column_name') from table_name;

You can use postgresql json data type (and its related features):

select row_to_json(table_name)->>(row_to_json(table_name)->>'column_name') from table_name;
Source Link
Radek Postołowicz
Radek Postołowicz
  • 4.9k
  • 2
  • 32
  • 52

Here you are:

select row_to_json(table_name)->>(row_to_json(table_name)->>'column_name') from table_name;