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