If I understood you correctly, you can try something like this from the command line:
su postgres -c "psql dspace -c 'select name, collection_id from collection;'" -Mika > Hi! > > > > Is there a way to find out collection id and collection name from > postgresql. From dspace-admin we can find this out, but requires > searching for each collection and corresponding id. Is there an easy way > to find this for batch importing? > > > > I searched HANDLE table and COLLECTION table but couldn’t succeed. > > > > Thanks, > > Jayan > > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Mika Stenberg IT-asiantuntija Terveystieteiden Keskuskirjasto Lääketieteellinen tdk PL 61 (Haartmaninkatu 4) Helsingin Yliopisto 00290 Helsinki puh. +358-9-191 26807 ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
