room_alias_servers

5 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ room_alias server
1 1 #telegram_TelegramTips:matrix.jamesst.one matrix.jamesst.one
2 2 #telegram_contest:matrix.jamesst.one matrix.jamesst.one
3 3 #telegram_BotNews:matrix.jamesst.one matrix.jamesst.one
4 4 #telegram_PINE64_News:matrix.jamesst.one matrix.jamesst.one
5 5 #telegram_dust_announce:matrix.jamesst.one matrix.jamesst.one

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE room_alias_servers( room_alias TEXT NOT NULL, server TEXT NOT NULL );
CREATE INDEX room_alias_servers_alias ON room_alias_servers(room_alias);