MySQL & PostgreSQL 小命令对比

疯子的紫梦 posted @ 2010年4月23日 21:16 in Postgre , 1212 阅读

对比下一些两个数据库常用的操作。分别使用自带的client程序。

MySQL命令行：

mysql -u 用户名 -h 主机地址 -P 端口号 数据库名 -p

PostgreSQL命令行：

psql -U 用户名 -h 主机地址 -p 端口号 数据库名

操作对比：

mysql                      psql

SHOW DATABASES;           \l
USE db-name;              \c db-name
SHOW TABLES;              \d
SHOW USERS;               \du
SHOW COLUMNS;             \d table-name
SHOW PROCESSLIST;         SELECT * FROM pg_stat_activity;
SELECT now()\G            \x 可以打开和关闭类似\G功能
SOURCE /path.sql          \i /path.sql
LOAD DATA INFILE ...      \copy ...
\h                        \?

[回复]

CBSE 1st Class Ques 说:
2023年9月07日 16:00

Students Can Check These CBSE Question Paper 2024 All Subjects are Upload by According to the Changed Exam Pattern CBSE Final Examination 2024, Students With the help of CBSE Model Paper 2024 Students may Understand the Pdf Format and type of Blueprint to be asked in Final Exam and they can also know the design of CBSE Question Paper 2024 according to which they can Formulate an CBSE 1st Class Question Paper 2024 Effective plan for their 1st Class Exam Preparations.Central Board has Recently Upload CBSE Important Question Paper 2024 of All Subjects English, Hindi, Science, Social Science, Maths, With the help of These CBSE Solved Questions Paper 2024 Students can Anticipate the Structure of Previous Papers they will get in Exam 2024,