You can read the background about the change and a practical example here: https://wiki.duraspace.org/display/DSPACE/Metadata+for+all+DSpace+objects
The point is you can find all the metadata in the metadatavalue table, an EAV table, which is why you couldn't find the metadata field names as column names anywhere. You may also find the ds6_metadata_id2field() and ds6_collectionhandle2collection() functions (or just their code) helpful: https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace+6 Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Mon, Feb 12, 2018 at 12:55 PM, Michael White <michael.wh...@stir.ac.uk> wrote: > Hi, > > > > 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 > > '%introductory_text%'; > > > > - but still no joy L > > > > 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!) . . . > > > > Cheers, > > > > Mike > > > > Michael White > > Senior Developer > > Business Applications and Integrations > > > > T: (01786) 466877 > > E: michael.wh...@stir.ac.uk > > A: G5, Airthrey Castle, University of Stirling, Stirling, FK9 4LA > > > > ________________________________ > The University achieved an overall 5 stars in the QS World University > Rankings 2016/17 > 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 dspace-tech+unsubscr...@googlegroups.com. > To post to this group, send email to dspace-tech@googlegroups.com. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. -- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
