Multiple tables row insertions from single psql input file

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Multiple tables row insertions from single psql input file
Date: 2024-06-10 18:50:27
Message-ID: 7da8ec9-089-74ce-eb3-c88889b62c64@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message veem v 2024-06-10 19:17:14 Does trigger only accept functions?
Previous Message Dominique Devienne 2024-06-10 18:43:28 Re: libpq v17 PQsocketPoll timeout is not granular enough