title: Postgresql - return entire row as array
body: <p>Is there a way how you can cast the following result to array?</p>
  
  <pre><code>select pg_tables from pg_tables
  </code></pre>
  
  <p>This will return one column only, however the data type is not array.</p>
  
  <p>Edit: I'm using PostgreSql 9.1.4</p>
  
  <p>Update: I need an equivalent of the following SQL statement, without the need to write column names, applicable for every table:</p>
  
  <pre><code>select 
      string_to_array(
      schemaname || '|' ||
      tablename || '|' || 
      tableowner || '|' ||
      coalesce(tablespace,'') || '|' ||
      hasindexes || '|' ||
      hasrules || '|' ||
      hastriggers
      ,'|')
  from 
      pg_tables
  </code></pre>