Moodle ile işlenen canlı Bigbluebutton derslerinin listesini CSV olarak almak için.
Postgresql sunucuya login ol.
su postgres
psql
\copy (SELECT metadata.recording_id,
metadata."key", metadata."value",
playback_formats."length"
FROM metadata INNER JOIN
playback_formats ON
metadata.recording_id =
playback_formats.recording_id WHERE
metadata."key" = 'bbb-context-name')
to '/var/lib/pgsql/liste.csv' with csv