Hexo

Home Archives
2016-05-03

PostgreSQL显示枚举类型内容列表

PostgreSQL中如何查看枚举类型的值列表呢?

举个例子,执行如下SQL:

1
CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple');

顺序返回全部枚举值

1
2
3
4
5
SELECT enum_range(NULL::rainbow);
enum_range
------------------
{red,orange,yellow,green,blue,purple}
(1 row)

参考:Enum Support Functions

Share
  • PostgreSQL
Newer
How to Convert Python dict to object?
Older
提交代码时来张自拍

Tags

  • CSS
  • Chrome
  • Coding
  • DB
  • DEBUG
  • Docker
  • Git
  • HTTP
  • Java
  • LOG
  • Linux
  • MySQL
  • Nginx
  • PostgreSQL
  • Python
  • Redis
  • TODO
  • Ubuntu
  • api-test, test, bdd
  • database, migrate, java
  • html5 note
  • java,springboot,actuator,schedule
  • unittest
  • 点子
  • 笔记
  • 翻译

Tag Cloud

CSS Chrome Coding DB DEBUG Docker Git HTTP Java LOG Linux MySQL Nginx PostgreSQL Python Redis TODO Ubuntu api-test, test, bdd database, migrate, java html5 note java,springboot,actuator,schedule unittest 点子 笔记 翻译

Archives

  • May 2022
  • March 2020
  • December 2019
  • November 2019
  • August 2017
  • May 2016
  • November 2015
  • September 2015
  • July 2015
  • April 2015
  • October 2014
  • May 2014

Recent Posts

  • iOS如何下载并使用科学上网(翻墙)
  • SpringBoot actuator监控定时任务执行时间
  • 数据库版本管理工具Liquibase
  • 接口测试框架Karate入门
  • HTML5内容折叠
© 2022 John Doe
Powered by Hexo
Home Archives