Date: Mon, 10 Jun 2024 11:50:27 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
Reply-To: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Multiple tables row insertions from single psql input file
Message-ID: <7da8ec9-089-74ce-eb3-c88889b62c64@appl-ecosys.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
Archived-At: <https://www.postgresql.org/message-id/7da8ec9-089-74ce-eb3-c88889b62c64%40appl-ecosys.com>
Precedence: bulk

My business tracking database has three main tables: company, location,
contact. The company and contact primary keys are sequences.

I've been adding new rows using INSERT INTO files separately for each table
after manually finding the last PK for the company and contact tables. The
location table has the company PK as a FK; the contact table has both
company PK and location PK as foreign keys.

Now I will use next_val 'PK' to assign the value for each new table row.

My question is whether I can create new rows for all three tables in the
same sql source file. Since the location and contact tables require sequence
numbers from the company and location tables is there a way to specify,
e.g., current_val 'tablename PK' for the related tables? Or, do I still need
to enter all new companies before their locations and contact?

TIA,

Rich