- or download this
{ 'order_code' => '0165-02675-4565', 'email' => 'foo@test.com', 'pric
+e' => '15', 'title' => 'Mt Thing XYZ' };
- or download this
create index junk7_gin_idx using gin (data);
- or download this
select * from junk7 where data @> '{ "email": "abcd@text.com" }';
- or download this
#!/bin/sh
for power in 7;
...
" | psql
echo "\dti+ ${table}*" | psql -qX
done
- or download this
-- table junk7
id | data
...
public | junk7_gin_idx | index | aardvark | junk7 | 177 MB |
(2 rows)