title: How to create table with datetime in its name using postgres sql
body: <p>Is there a way to create a table with date time on it's name purely using postgres sql.</p>
  
  <p>Consider the typical create table:</p>
  
  <pre><code>CREATE TABLE someNewTable AS SELECT .... FROM someSourceTable WHERE date &gt;= somedate AND date &lt;somedate;
  </code></pre>
  
  <p>What I need is to append the time stamp in a table name. The time stamp is dynamically created. I know this is not a common way but needed for archiving purpose. So is there a way to do this in pure postgres sql?</p>
  
  <pre><code>CREATE TABLE someNewTableYYYYMMDDHHMMSS AS SELECT .... FROM someSourceTable WHERE date &gt;= somedate AND date &lt;somedate;
  </code></pre>
  
  <p>Thanks in advance!</p>