Re: Function to return whole relation path?

David Christensen <david@endpoint.com> writes:
> On Feb 7, 2010, at 11:04 AM, Tom Lane wrote:
>> pg_relation_filepath(regclass) returns text
>> which would expose the output of relpath(), ie, the $PGDATA-relative
>> path name of the relation.

> Should this return multiple values (text[] or SETOF text) for tables  
> which wrapped over the single file-limits (1GB, IIRC)?  So: "pg_tblspc/ 
> 48372/8.5_201002061/68483/172744", "pg_tblspc/ 
> 48372/8.5_201002061/68483/172744.1", etc?

No, I'm not inclined to go there.  The set of actually existing segments
seems too volatile; and anyone worried about this probably can add a
star to the end of the pathname ...
        regards, tom lane