postgres由user-----database----schema-----table

因为schema是隶属于某个database的,所以创建后不能修改这个schema到新的一个database上 1 create user abc password ‘123456‘ ; 2 create database abcdb with owner=‘abc‘; 3 \c abcdb abc; 4 create schema abc authorization abc;(drop schem xxx cascade) 5 create table abc.test(id int);

postgres由user-----database----schema-----table

上一篇:虚拟机VMware—JDK Mysql Tomcat配置


下一篇:文件下载:报错The value of the 'Access-Control-Allow-Origin' header in the response must not be the wildcard '*' when the request's credentials mode is 'include'