title: postgresql - is there an alternative to datename() function in postgresql?
body: <p>I am finding alternatives to various functions of SQL Server in PostgreSQL.</p>
  
  <p>Is there an alternative to the following SQL Server code in PostgreSQL?</p>
  
  <p><code>SELECT DATENAME(WEEKDAY,CURRENT_TIMESTAMP)</code></p>
  
  <p>Note: The above query returns the "weekday-name" of the current day</p>