msdnchina的专栏@JiNan,ShanDong

感谢枯荣长老对本人的大力帮助

记录一下:今天(2018.04.26)博客访问量超过200万

记录一下:今天(2018.04.26)博客访问量超过200万仅作鞭策,“为中华之自主数据库崛起而写博客”

2018-04-26 21:35:39

阅读数:10

评论数:0

PostgreSQL数据库中的current_user和session_user

[postgres@pgserver ~]$ psql psql (10beta2) Type "help" for help. postgres=# select current_user, session_user; current_user | ses...

2018-04-26 16:35:01

阅读数:10

评论数:0

【转帖】怎么查看操作系统是bios启动方式还是uefi启动方式?

【转帖】怎么查看操作系统是bios启动方式还是uefi启动方式?.参考自:https://access.redhat.com/solutions/2147971环境Red Hat Enterprise Linux 6Red Hat Enterprise Linux 7问题How to identi...

2018-04-26 16:14:20

阅读数:9

评论数:0

PostgreSQL常用语句1

--查询出t_test表的relowner select c.relname,c.relowner,a.rolname from pg_class c,pg_authid a where c.relowner=a.oid and c.relname='t_test'; --查询出某个索引的索引...

2018-04-25 21:30:24

阅读数:16

评论数:0

pg10,pg_suqences和pg_sequence

Move sequences' metadata fields into a new pg_sequence system catalog (Peter Eisentraut) A sequence relation now stores only the fields that can...

2018-04-23 22:20:10

阅读数:14

评论数:0

PostgreSQL10当sequence 带有cache时,正常关闭PG Cluster时对sequence的影响

postgres=# select * from testa; id | info ----+----------- 1 | abc 2 | abcd 11 | test 3 | asdfghjkl 4 | asdf4 5 | asdf5 6 | asdf6...

2018-04-23 21:53:18

阅读数:60

评论数:0

PostgreSQL10版本中的自增列

[root@pgserver ~]# su - postgres Last login: Sun Apr 22 23:46:50 EDT 2018 on pts/2 [postgres@pgserver ~]$ psql psql (10beta2) Type "help" f...

2018-04-23 21:00:11

阅读数:28

评论数:0

What is the equivalent of Oracle's log checkpoint in MySQL?

What is the equivalent of Oracle's log checkpoint in MySQL? (文档 ID 1023110.1)

2018-04-23 13:07:16

阅读数:20

评论数:0

PostgreSQL中的替代变量

参考:https://www.postgresql.org/docs/current/static/app-psql.htmlpostgres=# select * from tab_lei_1; c1 | c2 ----+---- (0 rows) postgres=# \set abc...

2018-04-20 19:06:06

阅读数:22

评论数:0

psql登录非本机的数据库服务器时的提示

Microsoft Windows [版本 10.0.16299.371] (c) 2017 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>psql -h 192.168.80.148 -p 5432 -d pos...

2018-04-19 10:36:19

阅读数:32

评论数:0

Xmlparsing is different in 11g from 10g (文档 ID 1515401.1)

 Xmlparsing is different in 11g from 10g (文档 ID 1515401.1) Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Inf...

2018-04-18 13:39:11

阅读数:12

评论数:0

oracle数据库中的Sys.XMLType 和 XMLType Datatypes

参考自: Sys.XMLType vs. XMLType Datatypes (文档 ID 279843.1) PURPOSE ------- This article explains the difference between sys.xmltype and xmltyp...

2018-04-18 09:34:00

阅读数:15

评论数:0

在PostgreSQL中使用timestamp数据类型

参考自:https://www.postgresql.org/docs/10/static/functions-formatting.html To get three milliseconds, one must write 12.003, which the conversion...

2018-04-17 21:38:41

阅读数:20

评论数:0

PostgreSQL中的6大约束

PG中的6大约束,详情参考:https://www.postgresql.org/docs/current/static/ddl-constraints.html5.3.1. Check Constraints5.3.2. Not-Null Constraints5.3.3. Unique Con...

2018-04-17 17:29:36

阅读数:22

评论数:0

在PostgreSQL数据库中使用$$作为字符串的引用符号

参考自:https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html中的4.1.2.4. Dollar-quoted String Constants部分。大概意思是:$highgolei$t$highgolei$中的...

2018-04-16 19:37:26

阅读数:26

评论数:0

在PostgreSQL数据库中安装pageinspect extension

[root@pgserver contrib]# ls -lrt | grep page drwxrwxrwx. 4 1107 1107 4096 Jul 10 2017 pageinspect [root@pgserver contrib]# pwd /home/postgresql-10be...

2018-04-16 18:49:50

阅读数:20

评论数:0

OGG不支持MariaDB

1. https://docs.oracle.com/goldengate/c1221/gg-winux/GIMYS/system_requirements.htm#GIMYS109 2. Golden Gate Extract Not Capturing Changes From Mari...

2018-04-16 18:03:55

阅读数:15

评论数:0

psql的选项

[postgres@pgserver ~]$ psql --help psql is the PostgreSQL interactive terminal. Usage: psql [OPTION]... [DBNAME [USERNAME]] General options: -c...

2018-04-14 22:46:53

阅读数:18

评论数:0

RHEL7.5正式发布了

RHEL7.5 最近正式发布,如下是百度云的下载链接:链接:https://pan.baidu.com/s/1BnsXL4ju6o5QT1dpGPA5Hg 密码:5n5z如下是RHEL7.5的SHA-256校验码,我是截图的,并非手工复制的该校验码,并且截图中带有redhat.com的网址,为的是...

2018-04-14 22:04:32

阅读数:37

评论数:0

pg_settings.source列的各种取值

postgres=# select distinct source from pg_settings; source ---------------------- default command line configuration file client ...

2018-04-12 22:28:48

阅读数:19

评论数:0

提示
确定要删除当前文章?
取消 删除
关闭
关闭