Hi,

I know the existence of the "replicate" utility, but this is intended for a different database.

So, how do you "clone" some data in the same database? For example, imagine you have the typical application for accounting, where all the tables are filtered by the company you are using in each moment. And you want to copy a complete company into a new one, i.e. copy all the data belonging to one company to one new company, so at the end of the process, both companies have the same data, but obviously different primary and foreign keys amongst them.

Thanks.

See "Row Level Security" in database documentation.

Sorry, but what does "Row level security" has to be with my question?