Christopher B. Browne's Home Page
cbbrowne@acm.org

8.31. copyfields(integer)

Function Properties

PLPGSQLtext
Return a string consisting of what should be appended to a COPY statement to specify fields for the passed-in tab_id. In PG versions > 7.3, this looks like (field1,field2,...fieldn)
    declare
    	result text;
    	prefix text;
    	prec record;
    begin
    	result := '';
    	prefix := '(';   -- Initially, prefix is the opening paren
    
    	for prec in select slon_quote_input(a.attname) as column from sl_table t, pg_catalog.pg_attribute a where t.tab_id = $1 and t.tab_reloid = a.attrelid and a.attnum > 0 and a.attisdropped = false order by attnum
    	loop
    		result := result || prefix || prec.column;
    		prefix := ',';   -- Subsequently, prepend columns with commas
    	end loop;
    	result := result || ')';
    	return result;
    end;

Google

If this was useful, let others know by an Affero rating

Contact me at cbbrowne@acm.org