How to determine the version of Redshift database

Run the below query to determine the version of Redshift as well as the operating system of the underlying host.

select version();

See also  How to view table definition in Redshift Database