title: How do I copy data from one table to another in postgres using copy command
body: <p>We use copy command to copy data of one table to a file outside database.</p>
  <p>Is it possible to copy data of one table to another table using command.</p>
  <p>If yes can anyone please share the query.</p>
  <p>Or is there any better approach like we can use pg_dump or something like that.</p>