creative_hub select from fs_node id name path storage_id created_at up

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
creative_hub=# select * from fs_node;
id | name | path | storage_id | created_at | updated_at | archived_at | revision
----+---------------+-----------+------------+-------------------------------+-------------------------------+-------------+----------
38 | test1 | 1.38 | | 2019-08-22 18:52:37.547646+03 | 2019-08-22 18:52:37.547646+03 | | 1
1 | root | 1 | | 2019-08-21 19:20:39.207111+03 | 2019-08-21 19:20:39.208303+03 | | 1
32 | roo5etf1t | 1.38.32 | | 2019-08-22 18:52:37.546289+03 | 2019-08-22 18:52:37.547646+03 | | 1
2 | root4 | 1.38.32.2 | | 2019-08-22 15:28:33.766363+03 | 2019-08-22 15:28:33.7744+03 | | 1
creative_hub=# select * from fs_node where path @> '1.38.32.2' ;
id | name | path | storage_id | created_at | updated_at | archived_at | revision
----+-----------+-----------+------------+-------------------------------+-------------------------------+-------------+----------
38 | test1 | 1.38 | | 2019-08-22 18:52:37.547646+03 | 2019-08-22 18:52:37.547646+03 | | 1
1 | root | 1 | | 2019-08-21 19:20:39.207111+03 | 2019-08-21 19:20:39.208303+03 | | 1
32 | roo5etf1t | 1.38.32 | | 2019-08-22 18:52:37.546289+03 | 2019-08-22 18:52:37.547646+03 | | 1
2 | root4 | 1.38.32.2 | | 2019-08-22 15:28:33.766363+03 | 2019-08-22 15:28:33.7744+03 | | 1