public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rich Shepard <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Multiple tables row insertions from single psql input file
Date: Mon, 10 Jun 2024 13:06:13 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com>
References: <[email protected]>
	<CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com>

On Mon, 10 Jun 2024, Ron Johnson wrote:

> With enough clever scripting you can create a .sql file that does almost
> anything.

Ron,

My projects don't all use SQL so I'm far from a clever scripter. :-)

> Most useful to you will be some number of "ALTER TABLE <foo> DISABLE
> TRIGGER ALL;" statements near the beginning of the file, and their "ALTER
> TABLE ... ENABLE TRIGGER ALL;" counterparts near the end of the file.

Doesn't alter table primarily apply to existing row values for specific
columns rather than inserting new rows and their column values?

Thanks,

Rich

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Multiple tables row insertions from single psql input file
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox