Postgre: How to import UUID function into Postgre 9.3
来源:互联网 发布:js trim函数 编辑:程序博客网 时间:2024/05/02 04:19
1. Open a command console and go to the directory where you installed Postgre server.
e.g. D:\Program Files\PostgreSQL\9.3\bin>
2. Drill down into BIN folder and issue following command.
psql -d <database name> -U <username>
3. Issue CREATE EXTENSION command to import extension
CREATE EXTENSION "uuid-ossp" ;
NOTICE: There is a semicolon at the end of command.
4. After above steps, you can check if the extension has been imported successfully by calling following command.
select * from pg_extension;
5. If succeed, you should be able to see the list as below.
extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-----------+----------+--------------+----------------+------------+-----------+--------------
plpgsql | 10 | 11 | f | 1.0 | |
uuid-ossp | 89286 | 2200 | t | 1.0 | |
6. Now, you may generate UUID by uuid_generate_v4()
select uuid_generate_v4() ;
- Postgre: How to import UUID function into Postgre 9.3
- How to import Ocx into MFC project
- How to Import Products into Magento
- How to import xml data into excel
- How to import Gradle project into eclipse
- How to import products into Magento?
- How to import Gradle project into eclipse .
- Migrate ConcourseConnect from Postgre to MySQL
- postgre constraints
- postgre索引
- postgre笔记
- postgre数据库
- How to import a static library into your test project?
- How to import existing GIT repository into another?
- How to import an oracle dump into a different tablespace
- How to import a SQL Server .bak file into MySQL?
- [Android] How to import library into android studio
- how to import x509.pem pk8 file into jks(keystore)?
- 哪里可以买到真的听话药水★扣扣:6768387★
- RequireJS 与 AngularJS 集成(完整版)
- hadoop2.2.0+zookeeper3.4.5+hbase0.96.2+hive0.13.1分布式环境部署
- 程序人生的四个象限和两条主线
- 关于socket长连接的心跳包
- Postgre: How to import UUID function into Postgre 9.3
- OpenCV图像处理篇之阈值操作函数
- BaseAdapter应用分析及异步加载
- ios8中的UIScreen
- tigase在linux上的绿色安装
- semop异常分析
- ArcSDE初学者需要弄清楚的几个问题 A
- hdu 1257 WA
- strace