开发者

Get Create as Select Table History Statement

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜