Postgresql - return entire row as array

Viewed 17668

Is there a way how you can cast the following result to array?

select pg_tables from pg_tables

This will return one column only, however the data type is not array.

Edit: I'm using PostgreSql 9.1.4

Update: I need an equivalent of the following SQL statement, without the need to write column names, applicable for every table:

select 
    string_to_array(
    schemaname || '|' ||
    tablename || '|' || 
    tableowner || '|' ||
    coalesce(tablespace,'') || '|' ||
    hasindexes || '|' ||
    hasrules || '|' ||
    hastriggers
    ,'|')
from 
    pg_tables
4 Answers
Related