运用postgres常用方法

来源:互联网 发布:中文文本挖掘软件 编辑:程序博客网 时间:2024/06/07 00:05
  • psql下,显示全部数据库中全部表达方法

           select * from pg_tables;

               select * from pg_tables where not tablename like 'pg%' order by tablename;

               select * from pg_tables where tableowner = 'sak' order by tablename;

               select * from pg_tables where tablename like 'pg%' order by tablename;



  •              

 

 

原创粉丝点击