The pgloader Reference Manual

pgloader.asd.

pgloader (system).

pgloader.

pgloader.asd.

src (module).

pgloader.params.

• *client-min-messages* (special variable).
• *context* (special variable).
• *copy-batch-rows* (special variable).
• *copy-batch-size* (special variable).
• *default-tmpdir* (special variable).
• *dry-run* (special variable).
• *fd-path-root* (special variable).
• *identifier-case* (special variable).
• *log-filename* (special variable).
• *log-min-messages* (special variable).
• *mssql-settings* (special variable).
• *mysql-settings* (special variable).
• *on-error-stop* (special variable).
• *pg-settings* (special variable).
• *pgsql-reserved-keywords* (special variable).
• *prefetch-rows* (special variable).
• *preserve-index-names* (special variable).
• *report-stream* (special variable).
• *root-dir* (special variable).
• *rows-per-range* (special variable).
• *self-upgrade-immutable-systems* (special variable).
• *summary-pathname* (special variable).
• *version-string* (special variable).
• +os-code-error+ (special variable).
• +os-code-error-bad-source+ (special variable).
• +os-code-error-regress+ (special variable).
• +os-code-error-usage+ (special variable).
• +os-code-success+ (special variable).
• getenv-default (function).
• init-params-from-environment (function).
• on-error-stop (condition).

• *major-version* (special variable).
• *minor-version* (special variable).
• *release* (special variable).
• git-hash (function).
• on-error-condition (reader method).

params.lisp (file).

pgloader.asd.

src (module).

• pgloader.syslog.
• pgloader.source.fixed.
• pgloader.connection.
• pgloader.utils.
• pgloader.source.mssql.
• pgloader.source.csv.
• pgloader.archive.
• pgloader.pgsql.
• pgloader.logs.
• pgloader.queries.
• pgloader.parse-date.
• pgloader.transforms.
• pgloader.source.mysql.
• pgloader.pgcopy.
• pgloader.source.pgsql.
• pgloader.source.mssql.index-filter.
• pgloader.sql.
• pgloader.
• pgloader.source.copy.
• pgloader.catalog.
• pgloader.source.sqlite.
• pgloader.state.
• pgloader.parser.
• pgloader.source.ixf.
• pgloader.quoting.
• pgloader.sources.
• pgloader.ini.
• pgloader.citus.
• pgloader.load.
• pgloader.monitor.
• pgloader.source.db3.

pgloader.asd.

monkey (module).

pgloader.asd.

monkey (module).

pgloader.asd.

utils (module).

• list-encodings-and-aliases (function).
• make-external-format (function).
• show-encodings (function).

• *ccl-describe-character-encodings* (special variable).
• parse-ccl-encodings-desc (function).
• parse-ccl-encodings-desc-first-line (function).

pgloader.asd.

utils (module).

• *log-messengers* (special variable).
• start-logger (function).
• stop-logger (function).

• +nsec+ (constant).
• fraction-to-nsecs (function).

pgloader.asd.

utils (module).

• distribute (function).
• expand-user-homedir-pathname (function).
• pretty-print-bytes (function).
• split-range (function).
• unquote (function).

pgloader.asd.

utils (module).

• create-state (function).
• get-state-section (function).
• make-pgstate (function).
• make-state (function).
• pgstate-decf (function).
• pgstate-errs (reader).
• (setf pgstate-errs) (writer).
• pgstate-get-label (function).
• pgstate-incf (function).
• pgstate-new-label (function).
• pgstate-read (reader).
• (setf pgstate-read) (writer).
• pgstate-rows (reader).
• (setf pgstate-rows) (writer).
• pgstate-secs (reader).
• (setf pgstate-secs) (writer).
• pgstate-setf (function).
• pgstate-tables (reader).
• (setf pgstate-tables) (writer).
• pgstate-tabnames (reader).
• (setf pgstate-tabnames) (writer).
• pgtable-bytes (reader).
• (setf pgtable-bytes) (writer).
• pgtable-initialize-reject-files (method).
• pgtable-reject-data (reader).
• (setf pgtable-reject-data) (writer).
• pgtable-reject-logs (reader).
• (setf pgtable-reject-logs) (writer).
• pgtable-rows (reader).
• (setf pgtable-rows) (writer).
• pgtable-secs (reader).
• (setf pgtable-secs) (writer).
• pgtable-start (reader).
• (setf pgtable-start) (writer).
• pgtable-stop (reader).
• (setf pgtable-stop) (writer).
• state-data (reader).
• (setf state-data) (writer).
• state-postload (reader).
• (setf state-postload) (writer).
• state-preload (reader).
• (setf state-preload) (writer).
• state-secs (reader).
• (setf state-secs) (writer).

• copy-pgstate (function).
• copy-pgtable (function).
• copy-state (function).
• make-pgtable (function).
• pgstate (structure).
• pgstate-bytes (reader).
• (setf pgstate-bytes) (writer).
• pgstate-p (function).
• pgstate-rs (reader).
• (setf pgstate-rs) (writer).
• pgstate-ws (reader).
• (setf pgstate-ws) (writer).
• pgtable (structure).
• pgtable-errs (reader).
• (setf pgtable-errs) (writer).
• pgtable-name (reader).
• (setf pgtable-name) (writer).
• pgtable-p (function).
• pgtable-read (reader).
• (setf pgtable-read) (writer).
• pgtable-rs (reader).
• (setf pgtable-rs) (writer).
• pgtable-ws (reader).
• (setf pgtable-ws) (writer).
• reject-data-file (function).
• reject-log-file (function).
• relative-pathname (function).
• state (structure).
• state-bytes (reader).
• (setf state-bytes) (writer).
• state-p (function).

pgloader.asd.

utils (module).

pgloader.user-symbols.

• intern-symbol (function).
• parse-column-typemod (function).
• typemod-expr-matches-p (function).
• typemod-expr-to-function (function).

• arr-to-bytes-rev (macro).
• base64-decode (function).
• bits-to-boolean (function).
• bits-to-hex-bitstring (function).
• byte-vector-to-bytea (function).
• byte-vector-to-hexstring (function).
• convert-mysql-linestring (function).
• convert-mysql-point (function).
• date-with-no-separator (function).
• db3-date-to-pgsql-date (function).
• db3-numeric-to-pgsql-integer (function).
• db3-numeric-to-pgsql-numeric (function).
• db3-trim-string (function).
• empty-string-to-null (function).
• ensure-parse-integer (function).
• float-to-string (function).
• hex-to-dec (function).
• int-to-ip (function).
• integer-to-string (function).
• ip-range (function).
• logical-to-boolean (function).
• remove-null-characters (function).
• right-trim (function).
• set-to-enum-array (function).
• sql-server-bit-to-boolean (function).
• sql-server-uniqueidentifier-to-uuid (function).
• sqlite-timestamp-to-timestamp (function).
• time-with-no-separator (function).
• tinyint-to-boolean (function).
• unix-timestamp-to-timestamptz (function).
• varbinary-to-string (function).
• zero-dates-to-null (function).

pgloader.asd.

utils (module).

• print-object (method).
• read-queries (function).

• copy-parser (function).
• extend-current-tag (method).
• format-current-tag (method).
• make-parser (function).
• maybe-close-tags (method).
• parse-query (function).
• parser (structure).
• parser-filename (reader).
• (setf parser-filename) (writer).
• parser-p (function).
• parser-state (reader).
• (setf parser-state) (writer).
• parser-stream (reader).
• (setf parser-stream) (writer).
• parser-tags (reader).
• (setf parser-tags) (writer).
• pop-current-tag (method).
• push-new-tag (method).
• read-lines (function).
• reset-state (method).

pgloader.asd.

utils (module).

• sql (function).
• sql-url-for-variant (function).

• *fs* (special variable).
• *src* (special variable).
• load-static-directory (function).
• load-static-file (function).
• pathname-to-url (function).
• walk-sources-and-build-fs (function).

utils.lisp (file).

pgloader.asd.

utils (module).

• apply-identifier-case (function).
• build-identifier (function).
• camelcase-to-colname (function).
• ensure-quoted (function).
• ensure-unquoted (function).
• quoted-p (function).

quoting.lisp (file).

pgloader.asd.

utils (module).

• add-column (generic function).
• add-extension (generic function).
• add-field (method).
• add-fkey (generic function).
• add-index (generic function).
• add-schema (generic function).
• add-sqltype (generic function).
• add-table (generic function).
• add-view (generic function).
• cast (generic function).
• catalog (structure).
• catalog-distribution-rules (reader).
• (setf catalog-distribution-rules) (writer).
• catalog-name (reader).
• (setf catalog-name) (writer).
• catalog-schema-list (reader).
• (setf catalog-schema-list) (writer).
• catalog-types-without-btree (reader).
• (setf catalog-types-without-btree) (writer).
• column (structure).
• column-comment (reader).
• (setf column-comment) (writer).
• column-default (reader).
• (setf column-default) (writer).
• column-extra (reader).
• (setf column-extra) (writer).
• column-name (reader).
• (setf column-name) (writer).
• column-nullable (reader).
• (setf column-nullable) (writer).
• column-transform (reader).
• (setf column-transform) (writer).
• column-transform-default (reader).
• (setf column-transform-default) (writer).
• column-type-mod (reader).
• (setf column-type-mod) (writer).
• column-type-name (reader).
• (setf column-type-name) (writer).
• count-fkeys (generic function).
• count-indexes (generic function).
• count-tables (generic function).
• count-views (generic function).
• create-table (function).
• extension (structure).
• extension-list (generic function).
• extension-name (reader).
• (setf extension-name) (writer).
• extension-schema (reader).
• (setf extension-schema) (writer).
• field-name (generic function).
• find-extension (generic function).
• find-fkey (generic function).
• find-index (generic function).
• find-schema (generic function).
• find-table (generic function).
• find-view (generic function).
• fkey (structure).
• fkey-columns (reader).
• (setf fkey-columns) (writer).
• fkey-condef (reader).
• (setf fkey-condef) (writer).
• fkey-deferrable (reader).
• (setf fkey-deferrable) (writer).
• fkey-delete-rule (reader).
• (setf fkey-delete-rule) (writer).
• fkey-foreign-columns (reader).
• (setf fkey-foreign-columns) (writer).
• fkey-foreign-table (reader).
• (setf fkey-foreign-table) (writer).
• fkey-initially-deferred (reader).
• (setf fkey-initially-deferred) (writer).
• fkey-match-rule (reader).
• (setf fkey-match-rule) (writer).
• fkey-name (reader).
• (setf fkey-name) (writer).
• fkey-oid (reader).
• (setf fkey-oid) (writer).
• fkey-table (reader).
• (setf fkey-table) (writer).
• fkey-update-rule (reader).
• (setf fkey-update-rule) (writer).
• format-create-sql (generic function).
• format-default-value (generic function).
• format-drop-sql (generic function).
• format-table-name (generic function).
• index (structure).
• index-columns (reader).
• (setf index-columns) (writer).
• index-condef (reader).
• (setf index-condef) (writer).
• index-conname (reader).
• (setf index-conname) (writer).
• index-filter (reader).
• (setf index-filter) (writer).
• index-fk-deps (reader).
• (setf index-fk-deps) (writer).
• index-name (reader).
• (setf index-name) (writer).
• index-oid (reader).
• (setf index-oid) (writer).
• index-primary (reader).
• (setf index-primary) (writer).
• index-schema (reader).
• (setf index-schema) (writer).
• index-sql (reader).
• (setf index-sql) (writer).
• index-table (reader).
• (setf index-table) (writer).
• index-type (reader).
• (setf index-type) (writer).
• index-unique (reader).
• (setf index-unique) (writer).
• make-catalog (function).
• make-column (function).
• make-fkey (function).
• make-index (function).
• make-matview (function).
• make-procedure (function).
• make-schema (function).
• make-sqltype (function).
• make-table (function).
• make-trigger (function).
• matview (structure).
• matview-definition (reader).
• (setf matview-definition) (writer).
• matview-name (reader).
• (setf matview-name) (writer).
• matview-schema (reader).
• (setf matview-schema) (writer).
• matview-source-name (reader).
• (setf matview-source-name) (writer).
• max-indexes-per-table (generic function).
• maybe-add-extension (generic function).
• maybe-add-fkey (generic function).
• maybe-add-index (generic function).
• maybe-add-schema (generic function).
• maybe-add-table (generic function).
• maybe-add-view (generic function).
• procedure (structure).
• procedure-body (reader).
• (setf procedure-body) (writer).
• procedure-language (reader).
• (setf procedure-language) (writer).
• procedure-name (reader).
• (setf procedure-name) (writer).
• procedure-returns (reader).
• (setf procedure-returns) (writer).
• procedure-schema (reader).
• (setf procedure-schema) (writer).
• push-to-end (macro).
• schema (structure).
• schema-catalog (reader).
• (setf schema-catalog) (writer).
• schema-extension-list (reader).
• (setf schema-extension-list) (writer).
• schema-in-search-path (reader).
• (setf schema-in-search-path) (writer).
• schema-name (reader).
• (setf schema-name) (writer).
• schema-source-name (reader).
• (setf schema-source-name) (writer).
• schema-sqltype-list (reader).
• (setf schema-sqltype-list) (writer).
• schema-table-list (reader).
• (setf schema-table-list) (writer).
• schema-view-list (reader).
• (setf schema-view-list) (writer).
• sqltype (structure).
• sqltype-extension (reader).
• (setf sqltype-extension) (writer).
• sqltype-extra (reader).
• (setf sqltype-extra) (writer).
• sqltype-list (method).
• sqltype-list (method).
• sqltype-list (method).
• sqltype-list (method).
• sqltype-name (reader).
• (setf sqltype-name) (writer).
• sqltype-schema (reader).
• (setf sqltype-schema) (writer).
• sqltype-source-def (reader).
• (setf sqltype-source-def) (writer).
• sqltype-type (reader).
• (setf sqltype-type) (writer).
• table (structure).
• table-citus-rule (reader).
• (setf table-citus-rule) (writer).
• table-column-list (reader).
• (setf table-column-list) (writer).
• table-comment (reader).
• (setf table-comment) (writer).
• table-field-list (reader).
• (setf table-field-list) (writer).
• table-fkey-list (reader).
• (setf table-fkey-list) (writer).
• table-index-list (reader).
• (setf table-index-list) (writer).
• table-list (generic function).
• table-name (reader).
• (setf table-name) (writer).
• table-oid (reader).
• (setf table-oid) (writer).
• table-row-count-estimate (reader).
• (setf table-row-count-estimate) (writer).
• table-schema (reader).
• (setf table-schema) (writer).
• table-source-name (reader).
• (setf table-source-name) (writer).
• table-storage-parameter-list (reader).
• (setf table-storage-parameter-list) (writer).
• table-tablespace (reader).
• (setf table-tablespace) (writer).
• table-trigger-list (reader).
• (setf table-trigger-list) (writer).
• trigger (structure).
• trigger-action (reader).
• (setf trigger-action) (writer).
• trigger-name (reader).
• (setf trigger-name) (writer).
• trigger-p (function).
• trigger-procedure (reader).
• (setf trigger-procedure) (writer).
• trigger-table (reader).
• (setf trigger-table) (writer).
• view-list (generic function).
• with-schema (macro).

• add-comment (generic function).
• catalog-p (function).
• column-p (function).
• column-table (reader).
• (setf column-table) (writer).
• copy-catalog (function).
• copy-column (function).
• copy-extension (function).
• copy-fkey (function).
• copy-index (function).
• copy-matview (function).
• copy-procedure (function).
• copy-schema (function).
• copy-sqltype (function).
• copy-table (function).
• copy-trigger (function).
• extension-p (function).
• fkey-p (function).
• fkey-pkey (reader).
• (setf fkey-pkey) (writer).
• index-p (function).
• make-extension (function).
• matview-p (function).
• procedure-p (function).
• schema-matview-list (reader).
• (setf schema-matview-list) (writer).
• schema-p (function).
• sqltype-p (function).
• table-p (function).

catalog.lisp (file).

pgloader.asd.

utils (module).

• alter-schema (generic function).
• alter-table (generic function).
• make-match-rule (function).
• make-regex-match-rule (function).
• make-string-match-rule (function).
• match-rule (structure).
• match-rule-action (reader).
• (setf match-rule-action) (writer).
• match-rule-args (reader).
• (setf match-rule-args) (writer).
• match-rule-rule (reader).
• (setf match-rule-rule) (writer).
• match-rule-schema (reader).
• (setf match-rule-schema) (writer).
• matches (generic function).
• regex-match-rule (structure).
• regex-match-rule-target (reader).
• (setf regex-match-rule-target) (writer).
• string-match-rule (structure).
• string-match-rule-target (reader).
• (setf string-match-rule-target) (writer).

• alter-schema-rename (function).
• alter-table-rename (function).
• alter-table-set-schema (function).
• alter-table-set-storage-parameters (function).
• alter-table-set-tablespace (function).
• copy-match-rule (function).
• copy-regex-match-rule (function).
• copy-string-match-rule (function).
• match-rule-p (function).
• regex-match-rule-p (function).
• reset-sql-definitions (function).
• rule-matches (generic function).
• string-match-rule-p (function).

catalog.lisp (file).

pgloader.asd.

utils (module).

• citus-backfill-table-p (function).
• citus-distribute-schema (function).
• citus-distributed-rule (structure).
• citus-distributed-rule-from (reader).
• (setf citus-distributed-rule-from) (writer).
• citus-distributed-rule-p (function).
• citus-distributed-rule-table (reader).
• (setf citus-distributed-rule-table) (writer).
• citus-distributed-rule-using (reader).
• (setf citus-distributed-rule-using) (writer).
• citus-format-sql-select (function).
• citus-reference-rule (structure).
• citus-reference-rule-p (function).
• citus-reference-rule-table (reader).
• (setf citus-reference-rule-table) (writer).
• citus-rule-is-missing-from-list (condition).
• citus-rule-table-not-found (condition).
• make-citus-distributed-rule (function).
• make-citus-reference-rule (function).
• print-object (method).
• print-object (method).

• add-column-to-pkey (function).
• apply-citus-rule (generic function).
• citus-find-table (function).
• citus-rule (reader method).
• (setf citus-rule) (writer method).
• citus-rule-table (generic function).
• citus-rule-table-not-found-schema-name (reader method).
• (setf citus-rule-table-not-found-schema-name) (writer method).
• citus-rule-table-not-found-table-name (reader method).
• (setf citus-rule-table-not-found-table-name) (writer method).
• citus-set-table (generic function).
• compute-foreign-rules (generic function).
• copy-citus-distributed-rule (function).
• copy-citus-reference-rule (function).
• format-citus-join-clause (function).
• make-distributed-table-from-fkey (function).

state.lisp (file).

pgloader.asd.

utils (module).

%process-bad-row (function).

state.lisp (file).

pgloader.asd.

utils (module).

• encode (method).
• encode (method).
• encode (method).
• encode (method).

• copy-print-format (function).
• copy-print-format-copy (function).
• copy-print-format-csv (function).
• copy-print-format-human-readable (function).
• copy-print-format-json (function).
• copy-print-format-tab (function).
• copy-print-format-text (function).
• copy-print-format-verbose (function).
• define-yason-encoder (macro).
• format-interval-guess (function).
• make-print-format (function).
• make-print-format-copy (function).
• make-print-format-csv (function).
• make-print-format-human-readable (function).
• make-print-format-json (function).
• make-print-format-tab (function).
• make-print-format-text (function).
• make-print-format-verbose (function).
• pf-legend (reader).
• (setf pf-legend) (writer).
• pf-max-label-length (reader).
• (setf pf-max-label-length) (writer).
• pretty-print (generic function).
• print-format (structure).
• print-format-copy (structure).
• print-format-copy-p (function).
• print-format-csv (structure).
• print-format-csv-p (function).
• print-format-human-readable (structure).
• print-format-human-readable-p (function).
• print-format-json (structure).
• print-format-json-p (function).
• print-format-p (function).
• print-format-tab (structure).
• print-format-tab-p (function).
• print-format-text (structure).
• print-format-text-legend (function).
• (setf print-format-text-legend) (function).
• print-format-text-max-label-length (function).
• (setf print-format-text-max-label-length) (function).
• print-format-text-p (function).
• print-format-verbose (structure).
• print-format-verbose-legend (function).
• (setf print-format-verbose-legend) (function).
• print-format-verbose-max-label-length (function).
• (setf print-format-verbose-max-label-length) (function).
• print-format-verbose-p (function).

• state.lisp (file).
• pretty-print-state.lisp (file).
• utils.lisp (file).
• catalog.lisp (file).

pgloader.asd.

utils (module).

report-full-summary (function).

• format-interval (function).
• max-length-table-name (function).
• parse-summary-type (function).

• logs.lisp (file).
• state.lisp (file).
• reject.lisp (file).
• report.lisp (file).

pgloader.asd.

utils (module).

• *monitoring-kernel* (special variable).
• *monitoring-queue* (special variable).
• elapsed-time-since (function).
• flush-summary (function).
• log-message (macro).
• log-message (structure).
• monitor-error (condition).
• new-label (function).
• new-label (structure).
• process-bad-row (function).
• report-summary (structure).
• send-event (function).
• start-monitor (function).
• stop-monitor (function).
• timing (macro).
• update-stats (function).
• update-stats (structure).
• with-monitor (macro).
• with-stats-collection (macro).

• *monitoring-channel* (special variable).
• *sections* (special variable).
• bad-row (structure).
• bad-row-condition (reader).
• (setf bad-row-condition) (writer).
• bad-row-data (reader).
• (setf bad-row-data) (writer).
• bad-row-label (reader).
• (setf bad-row-label) (writer).
• bad-row-p (function).
• bad-row-section (reader).
• (setf bad-row-section) (writer).
• call-with-monitor (function).
• copy-bad-row (function).
• copy-log-message (function).
• copy-new-label (function).
• copy-report-summary (function).
• copy-start (function).
• copy-stop (function).
• copy-update-stats (function).
• log-message-arguments (reader).
• (setf log-message-arguments) (writer).
• log-message-category (reader).
• (setf log-message-category) (writer).
• log-message-description (reader).
• (setf log-message-description) (writer).
• log-message-p (function).
• make-bad-row (function).
• make-log-message (function).
• make-new-label (function).
• make-report-summary (function).
• make-start (function).
• make-stop (function).
• make-update-stats (function).
• maybe-log-progress-message (function).
• monitor (function).
• monitor-real-error (reader method).
• new-label-dbname (reader).
• (setf new-label-dbname) (writer).
• new-label-label (reader).
• (setf new-label-label) (writer).
• new-label-p (function).
• new-label-section (reader).
• (setf new-label-section) (writer).
• process-update-stats-start-event (function).
• process-update-stats-stop-event (function).
• report-current-summary (function).
• report-summary-p (function).
• report-summary-reset (reader).
• (setf report-summary-reset) (writer).
• send-log-message (function).
• start (structure).
• start-p (function).
• start-start-logger (reader).
• (setf start-start-logger) (writer).
• stop (structure).
• stop-p (function).
• stop-stop-logger (reader).
• (setf stop-stop-logger) (writer).
• update-stats-bytes (reader).
• (setf update-stats-bytes) (writer).
• update-stats-errs (reader).
• (setf update-stats-errs) (writer).
• update-stats-label (reader).
• (setf update-stats-label) (writer).
• update-stats-p (function).
• update-stats-read (reader).
• (setf update-stats-read) (writer).
• update-stats-rows (reader).
• (setf update-stats-rows) (writer).
• update-stats-rs (reader).
• (setf update-stats-rs) (writer).
• update-stats-secs (reader).
• (setf update-stats-secs) (writer).
• update-stats-section (reader).
• (setf update-stats-section) (writer).
• update-stats-start (reader).
• (setf update-stats-start) (writer).
• update-stats-stop (reader).
• (setf update-stats-stop) (writer).
• update-stats-ws (reader).
• (setf update-stats-ws) (writer).

monitor.lisp (file).

pgloader.asd.

utils (module).

make-kernel (function).

monitor.lisp (file).

pgloader.asd.

utils (module).

• archivep (function).
• expand-archive (function).
• get-matching-filenames (function).
• http-fetch-file (function).

• *http-buffer-size* (special variable).
• *supported-archive-types* (special variable).
• archive-type (function).
• gunzip (function).
• untar (function).
• unzip (function).

• monitor.lisp (file).
• archive.lisp (file).

pgloader.asd.

utils (module).

• check-connection (generic function).
• clone-connection (generic function).
• close-connection (generic function).
• conn-handle (reader method).
• (setf conn-handle) (writer method).
• conn-type (reader method).
• (setf conn-type) (writer method).
• connection (class).
• connection-error (condition).
• db-connection (class).
• db-connection-error (condition).
• db-host (reader method).
• (setf db-host) (writer method).
• db-name (reader method).
• (setf db-name) (writer method).
• db-pass (reader method).
• (setf db-pass) (writer method).
• db-port (reader method).
• (setf db-port) (writer method).
• db-user (reader method).
• (setf db-user) (writer method).
• expand (generic function).
• fd-connection (class).
• fd-connection-error (condition).
• fd-path (reader method).
• (setf fd-path) (writer method).
• fetch-file (generic function).
• open-connection (generic function).
• print-object (method).
• print-object (method).
• query (generic function).
• with-connection (macro).

• connection-error-host (reader method).
• connection-error-mesg (reader method).
• connection-error-path (reader method).
• connection-error-port (reader method).
• connection-error-type (reader method).
• connection-error-user (reader method).
• fd-arch (reader method).
• (setf fd-arch) (writer method).
• fd-uri (reader method).
• (setf fd-uri) (writer method).

pgloader.asd.

pgsql (module).

• clone-connection (method).
• close-connection (method).
• initialize-instance (method).
• list-reserved-keywords (function).
• list-typenames-without-btree-support (function).
• open-connection (method).
• pgconn-major-version (reader method).
• (setf pgconn-major-version) (writer method).
• pgconn-table-name (reader method).
• (setf pgconn-table-name) (writer method).
• pgconn-use-ssl (reader method).
• (setf pgconn-use-ssl) (writer method).
• pgconn-variant (reader method).
• (setf pgconn-variant) (writer method).
• pgconn-version-string (reader method).
• (setf pgconn-version-string) (writer method).
• pgsql-connect-and-execute-with-timing (function).
• pgsql-connection (class).
• pgsql-execute (function).
• pgsql-execute-with-timing (function).
• postgresql-retryable (type).
• postgresql-unavailable (type).
• query (method).
• query (method).
• sanitize-user-gucs (function).
• with-pgsql-connection (macro).
• with-pgsql-transaction (macro).

• *pgconn-variant* (special variable).
• *pgsql-client-certificate* (special variable).
• *pgsql-client-key* (special variable).
• *redshift-reserved-keywords* (special variable).
• *retry-connect-delay* (special variable).
• *retry-connect-times* (special variable).
• *test/versions* (special variable).
• configuration-limit-exceeded (condition).
• get-unix-socket-dir (function).
• handling-pgsql-notices (macro).
• new-pgsql-connection (function).
• parse-postgresql-version-number (function).
• parse-postgresql-version-string (function).
• parse-postgresql-version-variant (function).
• set-postgresql-version (function).
• set-session-gucs (function).
• ssl-enable-p (method).
• test/parse-postgresql-version-string (function).
• too-many-connections (condition).

connection.lisp (file).

pgloader.asd.

pgsql (module).

• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-create-sql (method).
• format-default-value (method).
• format-drop-sql (method).
• format-drop-sql (method).
• format-drop-sql (method).
• format-drop-sql (method).
• format-drop-sql (method).
• format-drop-sql (method).
• format-drop-sql (method).
• format-drop-sql (method).

• *pgsql-default-values* (special variable).
• get-column-type-name-from-sqltype (function).
• index-access-method (function).

pgsql-ddl.lisp (file).

pgloader.asd.

pgsql (module).

• format-create-sql (method).
• format-create-sql (method).

pgsql-ddl-citus.lisp (file).

pgloader.asd.

pgsql (module).

• fetch-pgsql-catalog (function).
• list-all-columns (function).
• list-all-fkeys (function).
• list-all-indexes (function).
• list-all-sqltypes (function).
• list-missing-fk-deps (function).
• list-schemas (function).
• list-table-oids (function).
• make-including-expr-from-catalog (function).
• make-including-expr-from-view-names (function).

• *table-type* (special variable).
• filter-list-to-where-clause (function).
• format-table-name-as-including-exp (function).
• get-current-database (function).
• list-search-path (function).
• make-including-expr-from-table (function).
• normalize-extra (function).
• parse-index-column-names (function).
• query-table-schema (function).

pgsql-schema.lisp (file).

pgloader.asd.

pgsql (module).

merge-catalogs (function).

• *type-name-mapping* (special variable).
• check-table-columns (function).
• get-type-name (function).
• same-type-p (function).

merge-catalogs.lisp (file).

pgloader.asd.

pgsql (module).

• *pgsql-triggers-procedures* (special variable).
• build-trigger (function).
• process-triggers (function).

pgsql-trigger.lisp (file).

pgloader.asd.

pgsql (module).

• process-index-definitions (generic function).
• translate-index-filter (generic function).

pgsql-index-filter.lisp (file).

pgloader.asd.

pgsql (module).

• adjust-data-types (generic function).
• finalize-catalogs (function).

• *redshift-decimal-max-precision* (special variable).
• *redshift-supported-data-types* (special variable).
• *redshift-varchar-max-precision* (special variable).
• dumb-down-data-types-for-redshift (generic function).

• pgsql-trigger.lisp (file).
• pgsql-finalize-catalogs.lisp (file).

pgloader.asd.

pgsql (module).

• add-to-search-path (function).
• comment-on-tables-and-columns (function).
• create-distributed-table (function).
• create-extensions (function).
• create-indexes-again (function).
• create-indexes-in-kernel (function).
• create-pgsql-fkeys (function).
• create-schemas (function).
• create-sqltypes (function).
• create-tables (function).
• create-triggers (function).
• create-views (function).
• drop-indexes (function).
• drop-pgsql-fkeys (function).
• maybe-drop-indexes (function).
• reset-sequences (function).
• set-table-oids (function).
• truncate-tables (function).
• with-disabled-triggers (macro).

• create-table-list (function).
• create-table-sql-list (function).
• disable-triggers (function).
• enable-triggers (function).

pgloader.asd.

common (module).

• cleanup (generic function).
• clone-copy-for (generic function).
• columns (reader method).
• (setf columns) (writer method).
• concurrency-support (generic function).
• copy (class).
• copy-column-list (generic function).
• copy-format (reader method).
• (setf copy-format) (writer method).
• create-matviews (generic function).
• data-is-preformatted-p (generic function).
• db-copy (class).
• drop-matviews (generic function).
• encoding (reader method).
• (setf encoding) (writer method).
• fetch-columns (generic function).
• fetch-comments (generic function).
• fetch-foreign-keys (generic function).
• fetch-indexes (generic function).
• fetch-metadata (generic function).
• fields (reader method).
• (setf fields) (writer method).
• filter-list-to-where-clause (generic function).
• format-matview-name (generic function).
• get-column-list (generic function).
• get-column-sql-expression (generic function).
• header (reader method).
• (setf header) (writer method).
• initialize-instance (method).
• instanciate-table-copy-object (generic function).
• map-rows (generic function).
• md-copy (class).
• parse-header (generic function).
• preprocessor (reader method).
• (setf preprocessor) (writer method).
• process-rows (generic function).
• skip-lines (reader method).
• (setf skip-lines) (writer method).
• source (reader method).
• (setf source) (writer method).
• source-db (reader method).
• (setf source-db) (writer method).
• target (reader method).
• (setf target) (writer method).
• target-db (reader method).
• (setf target-db) (writer method).
• transforms (reader method).
• (setf transforms) (writer method).

• fetch-table-row-count (generic function).
• proprocess-row (generic function).
• queue-raw-data (generic function).

api.lisp (file).

pgloader.asd.

common (module).

• cleanup (method).
• copy-column-list (method).
• data-is-preformatted-p (method).
• instanciate-table-copy-object (method).
• preprocess-row (method).

methods.lisp (file).

pgloader.asd.

common (module).

• clone-copy-for (method).
• copy-column-list (method).
• map-rows (method).
• parse-header (method).
• preprocess-row (method).

md-methods.lisp (file).

pgloader.asd.

common (module).

• create-matviews (method).
• drop-matviews (method).
• format-matview-name (method).

matviews.lisp (file).

pgloader.asd.

common (module).

• *cast-rules* (special variable).
• *default-cast-rules* (special variable).
• apply-casting-rules (function).

• cast-rule-matches (function).
• make-pgsql-type (function).
• parse-column-unsigned (function).

casting-rules.lisp (file).

pgloader.asd.

common (module).

• close-connection (method).
• expand (method).
• expand-spec (generic function).
• fetch-file (method).
• get-pathname (function).
• md-connection (class).
• md-spec (reader method).
• (setf md-spec) (writer method).
• md-strm (reader method).
• (setf md-strm) (writer method).
• open-connection (method).
• print-object (method).

filter-directory (function).

files-and-pathnames.lisp (file).

pgloader.asd.

common (module).

• project-fields (function).
• reformat-then-process (function).

pgloader.asd.

csv (module).

guess-csv-params (function).

• *escape-quotes* (special variable).
• *separators* (special variable).
• get-file-sample (function).
• get-stream-sample (function).
• try-csv-params (function).

pgloader.asd.

csv (module).

• clone-copy-for (method).
• copy-csv (class).
• csv-connection (class).
• initialize-instance (method).
• parse-header (method).
• process-rows (method).

• csv-escape (reader method).
• (setf csv-escape) (writer method).
• csv-escape-mode (reader method).
• (setf csv-escape-mode) (writer method).
• csv-newline (reader method).
• (setf csv-newline) (writer method).
• csv-quote (reader method).
• (setf csv-quote) (writer method).
• csv-separator (reader method).
• (setf csv-separator) (writer method).
• csv-trim-blanks (reader method).
• (setf csv-trim-blanks) (writer method).
• source-type (reader method).
• (setf source-type) (writer method).

pgloader.asd.

fixed (module).

• get-first-lines (generic function).
• guess-fixed-specs (function).
• guess-fixed-specs-from-header (function).

fixed-guess.lisp (file).

pgloader.asd.

fixed (module).

• clone-copy-for (method).
• copy-fixed (class).
• fixed-connection (class).
• initialize-instance (method).
• parse-header (method).
• process-rows (method).

parse-row (function).

• common (module).
• csv (module).

pgloader.asd.

sources (module).

• clone-copy-for (method).
• copy-connection (class).
• copy-copy (class).
• data-is-preformatted-p (method).
• initialize-instance (method).
• process-rows (method).

• delimiter (reader method).
• (setf delimiter) (writer method).
• null-as (reader method).
• (setf null-as) (writer method).
• parse-row (function).

pgloader.asd.

db3 (module).

• *db3-default-cast-rules* (special variable).
• cast (method).

• copy-db3-coldef (function).
• db3-coldef (structure).
• db3-coldef-default (reader).
• (setf db3-coldef-default) (writer).
• db3-coldef-extra (reader).
• (setf db3-coldef-extra) (writer).
• db3-coldef-length (reader).
• (setf db3-coldef-length) (writer).
• db3-coldef-name (reader).
• (setf db3-coldef-name) (writer).
• db3-coldef-nullable (reader).
• (setf db3-coldef-nullable) (writer).
• db3-coldef-p (function).
• db3-coldef-type (reader).
• (setf db3-coldef-type) (writer).
• make-db3-coldef (function).

db3-cast-rules.lisp (file).

pgloader.asd.

db3 (module).

• clone-connection (method).
• close-connection (method).
• dbf-connection (class).
• initialize-instance (method).
• open-connection (method).

• fd-db3 (reader method).
• (setf fd-db3) (writer method).

db3-connection.lisp (file).

pgloader.asd.

db3 (module).

• copy-db3 (class).
• encoding (reader method).
• (setf encoding) (writer method).
• fetch-columns (method).
• initialize-instance (method).

db3-schema.lisp (file).

pgloader.asd.

db3 (module).

• fetch-metadata (method).
• instanciate-table-copy-object (method).
• map-rows (method).

pgloader.asd.

ixf (module).

cast (method).

• *ixf-pgsql-type-mapping* (special variable).
• cast-ixf-type (function).
• transform-function (function).

ixf-cast-rules.lisp (file).

pgloader.asd.

ixf (module).

• clone-connection (method).
• close-connection (method).
• initialize-instance (method).
• ixf-connection (class).
• open-connection (method).

ixf-connection.lisp (file).

pgloader.asd.

ixf (module).

• copy-ixf (class).
• fetch-columns (method).
• initialize-instance (method).

• timezone (reader method).
• (setf timezone) (writer method).

ixf-schema.lisp (file).

pgloader.asd.

ixf (module).

• fetch-metadata (method).
• instanciate-table-copy-object (method).
• map-rows (method).

pgloader.asd.

sqlite (module).

• *sqlite-default-cast-rules* (special variable).
• cast (method).

• coldef (structure).
• coldef-ctype (reader).
• (setf coldef-ctype) (writer).
• coldef-default (reader).
• (setf coldef-default) (writer).
• coldef-dtype (reader).
• (setf coldef-dtype) (writer).
• coldef-extra (reader).
• (setf coldef-extra) (writer).
• coldef-name (reader).
• (setf coldef-name) (writer).
• coldef-nullable (reader).
• (setf coldef-nullable) (writer).
• coldef-p (function).
• coldef-pk-id (reader).
• (setf coldef-pk-id) (writer).
• coldef-seq (reader).
• (setf coldef-seq) (writer).
• coldef-table-name (reader).
• (setf coldef-table-name) (writer).
• copy-coldef (function).
• ctype-to-dtype (function).
• make-coldef (function).
• normalize (function).

sqlite-cast-rules.lisp (file).

pgloader.asd.

sqlite (module).

• clone-connection (method).
• close-connection (method).
• initialize-instance (method).
• open-connection (method).
• query (method).
• sqlite-connection (class).

• *sqlite-db* (special variable).
• has-sequences (reader method).
• (setf has-sequences) (writer method).

sqlite-connection.lisp (file).

pgloader.asd.

sqlite (module).

• copy-sqlite (class).
• fetch-columns (method).
• fetch-foreign-keys (method).
• fetch-indexes (method).
• filter-list-to-where-clause (method).

• add-unlisted-primary-key-index (function).
• db (reader method).
• (setf db) (writer method).
• find-auto-increment-in-create-sql (function).
• find-sequence (function).
• is-index-pk (function).
• list-columns (function).
• list-fkeys (function).
• list-index-cols (function).
• list-indexes (function).
• list-tables (function).
• sqlite-encoding (function).
• sqlite-pragma-encoding (function).

sqlite-schema.lisp (file).

pgloader.asd.

sqlite (module).

• copy-column-list (method).
• fetch-metadata (method).
• map-rows (method).

parse-value (function).

pgloader.asd.

mssql (module).

• *mssql-default-cast-rules* (special variable).
• cast (method).
• field-name (method).

• copy-mssql-column (function).
• make-mssql-column (function).
• mssql-column (structure).
• mssql-column-character-maximum-length (reader).
• (setf mssql-column-character-maximum-length) (writer).
• mssql-column-character-set-name (reader).
• (setf mssql-column-character-set-name) (writer).
• mssql-column-collation-name (reader).
• (setf mssql-column-collation-name) (writer).
• mssql-column-ctype (method).
• mssql-column-datetime-precision (reader).
• (setf mssql-column-datetime-precision) (writer).
• mssql-column-default (reader).
• (setf mssql-column-default) (writer).
• mssql-column-identity (reader).
• (setf mssql-column-identity) (writer).
• mssql-column-name (reader).
• (setf mssql-column-name) (writer).
• mssql-column-nullable (reader).
• (setf mssql-column-nullable) (writer).
• mssql-column-numeric-precision (reader).
• (setf mssql-column-numeric-precision) (writer).
• mssql-column-numeric-precision-radix (reader).
• (setf mssql-column-numeric-precision-radix) (writer).
• mssql-column-numeric-scale (reader).
• (setf mssql-column-numeric-scale) (writer).
• mssql-column-p (function).
• mssql-column-schema (reader).
• (setf mssql-column-schema) (writer).
• mssql-column-table-name (reader).
• (setf mssql-column-table-name) (writer).
• mssql-column-type (reader).
• (setf mssql-column-type) (writer).