I want to extract details of the Collections in my DSpace 6 DEV system so was
just looking in the database (postgres) but can't seem to find what I'm looking
for, so I'm hoping someone might be able to shed some light . . . ?
In DSpace v4 I was able to pull the information I wanted from the table
"collections" (i.e. id, "name", "short description", "introductory text", etc)
. . .
However, in DSpace v6, the "collection" table has fewer columns, and is missing
all the "textual detail" relating to each Collection (so no "name",
"short_description" etc) . . .
I've perused the Database schema diagram
(https://wiki.duraspace.org/display/DSDOC6x/Storage+Layer) but I can't see
anywhere where this information appears to be held!?
I've also tried searching the database "information_schema" for appropriately
named columns - e.g.:
select table_name from information_schema.columns where column_name like
- but still no joy :(
Can someone put me out of my misery and point me to where I can find the
details relating to each Collection in the DB?
My ultimate goal here is to extract a mapping from Collection names to uuids
for use by an integration with our CRIS system (just in case it helps to know
where I'm heading with this!) . . .
Business Applications and Integrations
T: (01786) 466877
A: G5, Airthrey Castle, University of Stirling, Stirling, FK9 4LA
The University achieved an overall 5 stars in the QS World University Rankings
The University of Stirling is a charity registered in Scotland,
number SC 011159.
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to firstname.lastname@example.org.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.