Suppose I have a table like this:
subject | flag
----------------+------
this is a test | 2
subject
is of type text
, and flag
is of type int
. I would like to transform this table to something like this in Postgres:
token | flag
----------------+------
this | 2
is | 2
a | 2
test | 2
Is there an easy way to do this?
See Question&Answers more detail:os