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
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
Read more