Postgre: Some useful command of Postgre
来源:互联网 发布:路径动画导入unity3d 编辑:程序博客网 时间:2024/05/16 19:32
Postgre is a SQL like database. However, there are some difference between it and MySQL in the perspective of command.
1) show tables <==> \dt
Or use the select sentence:
SELECT * FROM pg_catalog.pg_tables
2) show databases <==> \l
Or use the select sentence:
select datname from pg_database;
3) Delete all the rows of a table:
DELETE FROM tablename;
If you need to have a filter:
DELETE FROM weather WHERE city = 'Hayward';
4) Switch to another dataset
\c databasename
0 0
- Postgre: Some useful command of Postgre
- Installation of postgre on RHEL4U2
- Installation of postgre sql on cygwin
- postgre constraints
- postgre索引
- postgre笔记
- postgre数据库
- some useful resources of Microsoft
- some useful functions of c++
- linux+tomcat+postgre配置
- postgre 的安装步骤
- postgre 工具下载
- postgre数据库备份shell
- postgre常见错误信息备忘
- Postgre 中的 null 列
- 配置postgre数据库服务器
- 写postgre 存储过程
- C#连接Postgre SQL
- GCD详细介绍
- java 中的this 关键字的用法
- 美国付费电视行业2015年财报大集合
- 多个Activity轮训切换的实现
- ExtJs布局详解
- Postgre: Some useful command of Postgre
- 动态规划初步总结(1)(51Nod,CODE[VS]为例题)
- Gartner:以下5种情况公司应该选择私有云而不是公有云
- 关于修改工具栏查询功能
- Kotlin学习笔记——属性和字段
- Django学习随手记(五)
- Android解析xml(3)---Pull解析
- HashMap
- PHP零碎笔记