diff --git a/sql/upgrades/041.sql b/sql/upgrades/041.sql
new file mode 100644
index 00000000..c79cc6a3
--- /dev/null
+++ b/sql/upgrades/041.sql
@@ -0,0 +1,21 @@
+-- SWH DB schema upgrade
+-- from_version: 40
+-- to_version: 41
+-- description: Open directory get by id
+
+insert into dbversion(version, release, description)
+      values(41, now(), 'Work In Progress');
+
+-- Retrieve information on directory from temporary table
+create or replace function swh_directory_get()
+    returns setof directory
+    language plpgsql
+as $$
+begin
+    return query
+	select d.id, d.dir_entries, d.file_entries, d.rev_entries
+        from tmp_directory t
+        inner join directory d on t.id = d.id;
+    return;
+end
+$$;