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?
精彩评论