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