Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. CREATE TABLE foo(myjson)
  2. AS VALUES ('{"foo":{"bar":1}}'::json);
  3.  
  4. CREATE TYPE bar ( a int, b text );
  5.  
  6. CREATE TABLE foo(mybar)
  7. AS VALUES ( (0,'foobar')::bar );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement