开发者

Get Create as Select Table History Statement

开发者 https://www.devze.com 2022-12-07 19:50 出处:网络
Postgres 12 table created as select from other table(s) create table t1 as select t2.col1, t3.col2 fro开发者_JS百科m t2

Postgres 12

table created as select from other table(s)

create table t1
as
select t2.col1, t3.col2
fro开发者_JS百科m t2
join t3 on t2.colx=t3.coly
where t2.col4='XYZ';

if table was created with above 'create as select' statement, is there any possibility that i can get above 'create as select' statement from the table 't1' definition or from somewhere else like 'information schema' etc?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号