首页 > 数据库 >【postgresql】基于多个合并UNION (ALL)查询结果创建数据表CREATE TABLE table_name

【postgresql】基于多个合并UNION (ALL)查询结果创建数据表CREATE TABLE table_name

时间:2023-01-11 17:59:03浏览次数:75  
标签:postgresql name movies UNION CREATE 数据表 table SELECT

【postgresql】基于多个合并UNION (ALL)查询结果创建数据表CREATE TABLE table_name

CREATE TABLE movies.movies_aliyundrive AS
SELECT * FROM movies."电视剧,纪录片"
UNION
SELECT * FROM movies."动漫动画"
UNION
SELECT * FROM movies."教程.课程.软件"
UNION
SELECT * FROM movies."小说.书.图片"
UNION
SELECT * FROM movies."影视音乐"

SELECT * FROM movies.movies_aliyundrive

参考链接

PostgreSQL创建表 - PostgreSQL教程
https://www.yiibai.com/postgresql/postgresql-create-table.html

标签:postgresql,name,movies,UNION,CREATE,数据表,table,SELECT
From: https://www.cnblogs.com/cxloge/p/17044519.html

相关文章