2023-07-14 PostgreSql查看列信息 PostgreSql查看列信息 select ordinal_position as Colorder, column_name as ColumnName, data_type as TypeName, coalesce(character_maximum_length, numeric_precision, -1) as Length, numeric_scale as Scale, case is_nullable when 'NO' then 0 else 1 en... Laughing 2023-07-14 数据库 802 阅读 0 评论 2023年07月14日 802 阅读 0 评论
2023-07-11 PostgreSQL实时查看数据库实例正在执行的SQL PostgreSQL实时查看数据库实例正在执行的SQL SELECT pid, datname, usename, client_addr, application_name, STATE, backend_start, xact_start, xact_stay, query_start, query_stay, REPLACE ( query, chr( 10 ), ' ' ) AS query FROM ( SELECT pgsa.pid AS pid, pgsa.datname AS datname, pgsa.usename AS usename, pgsa.client_addr client_addr, pgsa.application_name AS application_name, pgsa.STATE AS STATE, pgsa.backend_start AS backend_start,... Laughing 2023-07-11 数据库 510 阅读 0 评论 2023年07月11日 510 阅读 0 评论