copy_rows

Copies rows to a global or central table from a temporary table with the same name.

This function is typically used with the file loader and invoked using the E~ switch.

If you use this function without the file loader ensure that you create a temporary table as the same name as the target table and place the new rows into the temporary table.

Available in a network database and requires the star$modify role.

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	The name of the table to copy rows to.

Examples:

SELECT copy_rows('public.mytable'); -- copies rows to 'public.mytable' table