I am making the tables and naming them with a specific pattern.
Now I'm curious - if I start psql and will want to create a table named pg_am, what will happen? I presume psql will produce error saying that the system table with that name exists and the user can't create ome. Am I right?
You are wasting people's time asking a question like this when it takes but seconds to experiment.
Most of what you are doing should be considered something to test out and observe the behavior yourself. Formalize it as a test if possible if you rely heavily on it so you can be aware if a bug were to be introduced that broke such a behavior, or even just to get lots of exposure to concurrency if you are designing a system especially reliant on specific concurrent behavior.
As it stands the methodology you describe is quite non-traditional for a relational client-server database system.
