GuoWeiHua guoweihua1982

## PostgreSQL.sql
-- show all tables and columns and type definitions
SELECT s.schemaname,s.relname,a.attname,format_type(a.atttypid, a.atttypmod)
FROM pg_attribute a
INNER JOIN pg_stat_user_tables s ON s.relid = a.attrelid
WHERE a.attnum > 0
ORDER BY 1,2,3

## Slack聊天记录备份.md

      
        
          
            
              
              1 file
            
          
          
            
              
              1 fork
            
          
          
            
              
              0 comments
            
          
          
            
              
              5 stars
            
          
        
        
          
              
          
          
            
                guoweihua1982
                / Slack聊天记录备份.md
            
            
              Created
              July 4, 2019 07:03
            
              
                Slack聊天记录的备份和查看方法
              
          
        
      
        
  
      
    Slack聊天记录备份

课题

免费版Slack的workspace最多只支持最近的10000件聊天记录查看，如果能定期保存的话比较方便阅览。
聊天记录保存

使用下面的基于go语言开发的工具
	-- show all tables and columns and type definitions
	SELECT s.schemaname,s.relname,a.attname,format_type(a.atttypid, a.atttypmod)
	FROM pg_attribute a
	INNER JOIN pg_stat_user_tables s ON s.relid = a.attrelid
	WHERE a.attnum > 0
	ORDER BY 1,2,3