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 create a table in Redshift database