Pastebin

sogo=# \d
                      List of relations
 Schema |               Name               |   Type   | Owner 
--------+----------------------------------+----------+-------
 public | sogo_folder_info                 | table    | sogo
 public | sogo_folder_info_c_folder_id_seq | sequence | sogo
 public | sogo_user_profile                | table    | sogo
 public | sogoagvchris00135d0d78e          | table    | sogo
 public | sogoagvchris00135d0d78e_acl      | table    | sogo
 public | sogoagvchris00135d0d78e_quick    | table    | sogo
 public | sogoagvchris002019d9bd3          | table    | sogo
 public | sogoagvchris002019d9bd3_acl      | table    | sogo
 public | sogoagvchris002019d9bd3_quick    | table    | sogo
 public | sogocisikker001235aa56e          | table    | sogo
 public | sogocisikker001235aa56e_acl      | table    | sogo
 public | sogocisikker001235aa56e_quick    | table    | sogo
 public | sogocjcchris0017e7ef2c2          | table    | sogo
 public | sogocjcchris0017e7ef2c2_acl      | table    | sogo
 public | sogocjcchris0017e7ef2c2_quick    | table    | sogo
 public | sogocjcchris0025f2dbd23          | table    | sogo
 public | sogocjcchris0025f2dbd23_acl      | table    | sogo
 public | sogocjcchris0025f2dbd23_quick    | table    | sogo
 public | sogocjcchris00318c81e5a          | table    | sogo
 public | sogocjcchris00318c81e5a_acl      | table    | sogo
 public | sogocjcchris00318c81e5a_quick    | table    | sogo
 public | sogocjcchris004468188c7          | table    | sogo
 public | sogocjcchris004468188c7_acl      | table    | sogo
 public | sogocjcchris004468188c7_quick    | table    | sogo
 public | sogocjcchris005424bf501          | table    | sogo
 public | sogocjcchris005424bf501_acl      | table    | sogo
 public | sogocjcchris005424bf501_quick    | table    | sogo
 public | sogokajchris00125b7911f          | table    | sogo
 public | sogokajchris00125b7911f_acl      | table    | sogo
 public | sogokajchris00125b7911f_quick    | table    | sogo
 public | sogokajchris0021a561887          | table    | sogo
 public | sogokajchris0021a561887_acl      | table    | sogo
 public | sogokajchris0021a561887_quick    | table    | sogo
 public | sogolkpchris00112d5ab60          | table    | sogo
 public | sogolkpchris00112d5ab60_acl      | table    | sogo
 public | sogolkpchris00112d5ab60_quick    | table    | sogo
 public | sogolkpchris0024e7fccfa          | table    | sogo
 public | sogolkpchris0024e7fccfa_acl      | table    | sogo
 public | sogolkpchris0024e7fccfa_quick    | table    | sogo
 public | sogotdnsikke0010afc71f3          | table    | sogo
 public | sogotdnsikke0010afc71f3_acl      | table    | sogo
 public | sogotdnsikke0010afc71f3_quick    | table    | sogo
 public | sogotdnsikke00222998306          | table    | sogo
 public | sogotdnsikke00222998306_acl      | table    | sogo
 public | sogotdnsikke00222998306_quick    | table    | sogo
 public | sogotrhsikke00178ac8248          | table    | sogo
 public | sogotrhsikke00178ac8248_acl      | table    | sogo
 public | sogotrhsikke00178ac8248_quick    | table    | sogo
 public | sogotrhsikke0025728d1ac          | table    | sogo
 public | sogotrhsikke0025728d1ac_acl      | table    | sogo
 public | sogotrhsikke0025728d1ac_quick    | table    | sogo
 public | sogotrhsikke0031251955b          | table    | sogo
 public | sogotrhsikke0031251955b_acl      | table    | sogo
 public | sogotrhsikke0031251955b_quick    | table    | sogo
 public | sogotrhsikke004689723ce          | table    | sogo
 public | sogotrhsikke004689723ce_acl      | table    | sogo
 public | sogotrhsikke004689723ce_quick    | table    | sogo
(57 rows)

sogo=# select split_part(c_quick_location, '/', 5) from sogo_folder_info where c_folder_type = 'Contact';
          split_part           
-------------------------------
 sogoagvchris00135d0d78e_quick
 sogocjcchris0017e7ef2c2_quick
 sogocjcchris00318c81e5a_quick
 sogokajchris00125b7911f_quick
 sogolkpchris00112d5ab60_quick
 sogotdnsikke0010afc71f3_quick
 sogotrhsikke00178ac8248_quick
 sogotrhsikke0025728d1ac_quick
(8 rows)

sogo=# \d sogoagvchris00135d0d78e_quick
      Table "public.sogoagvchris00135d0d78e_quick"
      Column       |          Type          | Modifiers 
-------------------+------------------------+-----------
 c_name            | character varying(255) | not null
 c_givenname       | character varying(255) | 
 c_cn              | character varying(255) | 
 c_sn              | character varying(255) | 
 c_screenname      | character varying(255) | 
 c_l               | character varying(255) | 
 c_mail            | character varying(255) | 
 c_o               | character varying(255) | 
 c_ou              | character varying(255) | 
 c_telephonenumber | character varying(255) | 
 c_component       | character varying(10)  | not null
 c_categories      | character varying(255) | 
Indexes:
    "sogoagvchris00135d0d78e_quick_pkey" PRIMARY KEY, btree (c_name)

sogo=#