I'm passionate about all database, with 20+ years from dev to ops, from Oracle to PostgreSQL and now scaling to NewSQL distributed database YugabyteDB  🚀

I chat (too much?) on Twitter, write on blog.pachot.net (old posts on dbi-services, medium,...), love to meet people at conferences

\c postgres://franck:switzerland@yb1.pachot.net:5433/yb_demo_northwind

ysqlsh (11.2-YB-2.4.5.0-b0)
You are now connected to database "yb_demo_northwind" as user "franck".

with RELATIONAL
  ( "Name", "Company", "Role" )
 as ( VALUES
  ( 'Franck Pachot','Yugabyte','Developer Advocate' )
 ) select KEY_VALUE.* from RELATIONAL
 , lateral jsonb_each_text(to_jsonb(RELATIONAL))
 with ordinality as KEY_VALUE(name,value,"#")
 order by "#";

  name   |       value        | #
---------+--------------------+---
 Name    | Franck Pachot      | 1
 Role    | Developer Advocate | 2
 Company | Yugabyte           | 3