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.


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


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

Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk