1. 查询表名称 在psql状态下查询表名称:\dt SQL方式查看表名称:SELECT tablename FROM pg_tables;SELECT viewname FROM pg_views WHERE schemaname ='public'PostgreSQL获取数据库中所有view名 视图 SELECT viewname FROM pg_views WHERE schemaname ='public'2. 查询表...
SELECTattname as "name", typname as "type", atttypmod - 4 as "size"FROMpg_class AS aLEFT OUTER JOIN pg_attribute AS b ON (b.attrelid = a.oid)LEFT OUTER JOIN pg_type AS c ON (b.atttypid = c.oid)where a.relname = '' and attname='<fieldname>'and b.attstattar...
方法有两个:方法一:select schemaname,tablename,pg_relation_size(schemaname||'.'||tablename) as tabsize from pg_tables order by 3 desc;方法二:直接进到postgresql 的数据存放目录下。你只需要知道数据库的OID、表的OID,然后进到相应目录下使用ll -h命令就可以查看了。如下所示 cd data...
pg_control文件包含了关于PostgreSQL数据库的详细信息,包括:版本号: 控制文件的版本标识。系统表版本: 格式为四位年月日和一个N值,记录数据库系统表的版本。系统标识符: 64位整数,用于唯一标识数据库。实例状态: 包括starting up(初始化启动)、shut down(正常关闭)、shut down in recovery(...