Tuesday, November 2, 2021

script to find table creation time stamp or date in aws redshift database?

 script to find table creation time stamp or date in aws redshift database:

provide the table_name and schema  name and get the table created time from Redshift DB


SELECT                              

nspname AS schema_name,             

relname AS table_name,              

relcreationtime AS creation_time    

FROM pg_class_info c, pg_namespace n

WHERE c.relnamespace=n.oid          

AND reltype != 0                    

AND nspname='<schema_name>'    

AND relname='<table_name>';

No comments:

Post a Comment