Editing Updating Media Indexes on Synology NAS (section)

=== Checking on the current indexes ===

Use the postgreSQL interactive terminal:<ref>[http://wacha.ch/wiki/synology Synology Indexing] - Synology Wiki by Clemens Wacha</ref>

<syntaxhighlight lang="bash">
DiskStation> sudo psql mediaserver postgres
</syntaxhighlight>

To display a list of tables:

<syntaxhighlight lang="sql">
mediaserver=# \dt
         List of relations
 Schema |   Name    | Type  | Owner 
--------+-----------+-------+-------
 public | directory | table | admin
 public | music     | table | admin
 public | photo     | table | admin
 public | playlist  | table | admin
 public | video     | table | admin
(5 rows)
</syntaxhighlight>

To check the current number of indexed files:

<syntaxhighlight lang="sql">
select count(1) as music_count from music;
select count(1) as photo_count from photo;
select count(1) as video_count from video;
</syntaxhighlight>

To view the last file indexed:

<syntaxhighlight lang="sql">
select * from photo where id = (select max(id) from photo);
</syntaxhighlight>

To quit type

<syntaxhighlight lang="sql">
\q
</syntaxhighlight>