Forum Discussion
j_angelevski
4 years agoContributor III
Hi @mayank.singh,
By “similar” count do you mean “same” value in both objects ?
mayank_singh
4 years agoNew Contributor II
Hi @j.angelevski, Yes same value
Here is some sql to emit schema for a table. I’m sure there are other ways in Redshift.
SELECT "tablename", "column", "type" FROM PG_TABLE_DEF WHERE schemaname = 'public' AND tablename = 't1207' -> TABLENAME COLUMN TYPE t1207 id integer t1207 bigdecimal double precision