> You might use the copy command instead of insert, which is far faster. > If you want the fastest possible inserts, then probably copy is the way > to go instead of insert. > Here is copy command via API: > http://www.postgresql.org/docs/current/static/libpq-copy.html > Here is copy command via SQL: > http://www.postgresql.org/docs/8.4/static/sql-copy.html > Is there a command like COPY which will insert the data but skip all triggers and optionally integrity checks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
