Back to Details

postgres

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

PostgreSQL 🐘

PostgreSQL 🐘

PostgreSQL database management.
PostgreSQL数据库管理。

Setup

配置

bash
export DATABASE_URL="postgresql://user:pass@localhost:5432/dbname"
bash
export DATABASE_URL="postgresql://user:pass@localhost:5432/dbname"

Features

功能特性

  • SQL query execution
  • Schema management
  • Index optimization
  • Backup and restore
  • Performance monitoring
  • Extensions management
  • SQL查询执行
  • 模式管理
  • 索引优化
  • 备份与恢复
  • 性能监控
  • 扩展管理

Usage Examples

使用示例

"Show all tables"
"Run query: SELECT * FROM users"
"Create index on email column"
"Show slow queries"
"Show all tables"
"Run query: SELECT * FROM users"
"Create index on email column"
"Show slow queries"

Commands

命令

bash
psql "$DATABASE_URL" -c "SELECT * FROM users LIMIT 10"
bash
psql "$DATABASE_URL" -c "SELECT * FROM users LIMIT 10"

Safety Rules

安全规则

  1. ALWAYS confirm before destructive operations
  2. BACKUP before schema changes
  1. 务必在执行破坏性操作前进行确认
  2. 备份在修改模式前