Re: Multiple tables row insertions from single psql input file
От
Ron Johnson
Тема
Re: Multiple tables row insertions from single psql input file
Дата
Msg-id
CANzqJaBiwqb_9c-+Ot1YL3UtQsrDb9K7RO0unD2r3jFH7uxNSA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Multiple tables row insertions from single psql input file Rich Shepard <rshepard@appl-ecosys.com>
Re: Multiple tables row insertions from single psql input file "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Multiple tables row insertions from single psql input file Rich Shepard <rshepard@appl-ecosys.com>
Re: Multiple tables row insertions from single psql input file "David G. Johnston" <david.g.johnston@gmail.com>
Re: Multiple tables row insertions from single psql input file [RESOLVED] Rich Shepard <rshepard@appl-ecosys.com>
Re: Multiple tables row insertions from single psql input file Torsten Förtsch <tfoertsch123@gmail.com>
Re: Multiple tables row insertions from single psql input file Rich Shepard <rshepard@appl-ecosys.com>
Re: Multiple tables row insertions from single psql input file Ron Johnson <ronljohnsonjr@gmail.com>
Re: Multiple tables row insertions from single psql input file Rich Shepard <rshepard@appl-ecosys.com>
Re: Multiple tables row insertions from single psql input file Ron Johnson <ronljohnsonjr@gmail.com>
Re: Multiple tables row insertions from single psql input file "David G. Johnston" <david.g.johnston@gmail.com>
Re: Multiple tables row insertions from single psql input file Ron Johnson <ronljohnsonjr@gmail.com>
On Mon, Jun 10, 2024 at 4:06 PM Rich Shepard <rshepard@appl-ecosys.com> wrote:
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. :-)
No one is born a scripter, much less 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?
I don't think so. For example, pg_dump has an option to add those DISABLE/ENABLE TRIGGER statements. It makes bulk loading of records much simpler.
В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
