In this page we explain how to connect to the repository data base and some usefull queries:
- Connection example:
psql -U rawdata -d rawdata -h 130.183.207.76 -p 5432
- List raw_data_gid, owner, upload_date
SELECT raw_data_gid, owner, upload_date
FROM raw_data
JOIN upload_chunk ON upload_chunk.upload_chunk_id = raw_data.upload_chunk_id
JOIN upload ON upload.upload_id = upload_chunk.upload_id;
- List uploads_id and raw_data_gid:
SELECT raw_data_gid, upload.upload_id
FROM raw_data
JOIN upload_chunk ON upload_chunk.upload_chunk_id = raw_data.upload_chunk_id
JOIN upload ON upload.upload_id = upload_chunk.upload_id;
- List uploads_name and raw_data_gid:
SELECT raw_data_gid, upload.upload_name
FROM raw_data
JOIN upload_chunk ON upload_chunk.upload_chunk_id = raw_data.upload_chunk_id
JOIN upload ON upload.upload_id = upload_chunk.upload_id;
- List upload_name, upload_path, relative_path and raw_data_gid
SELECT upload.upload_name, upload_path, relative_path, raw_data_gid
FROM raw_data
JOIN upload_chunk ON upload_chunk.upload_chunk_id = raw_data.upload_chunk_id
JOIN upload ON upload.upload_id = upload_chunk.upload_id;