Commit Graph

28 Commits

Author SHA1 Message Date
Dimitri Fontaine
925996000b
Improve pgloader docs (Table of Contents, titles, organisation). (#1440)
Make it easier to nagivate our docs, which are dense enough to warrant
proper organisation and guided Table of Contents.
2022-10-18 17:28:34 +02:00
Dimitri Fontaine
8d97a313fa
Improve documentation with command lines and defaults. (#1415)
* Improve documentation with command lines and defaults.

The advanced documentation coverage skipped the simple approach and didn't
explain fully what to do with the sample commands.

Fixes #1413.

* Fix docs indentation in the MySQL connection string options.

* Desultory docs and docs config fixes.
2022-08-12 15:27:40 +02:00
Vincent GRAILLOT
55d76af6c9 Fix documentation typo
CSV Source Specification: From
One of special values are `FILENAME MATCHING` and not `FILENAMES MATCHING`
2022-06-24 14:13:20 +02:00
Christoph Berg
11dc31d05c docs/ref/pgsql-redshift.rst: Fix too short title underline 2021-12-22 17:07:31 +01:00
ChristophKaser
40f6ba1ff4 Fixes typo in MS SQL Migration Options docs 2021-12-21 10:20:39 +01:00
marcel-tomes
a8512e60fa Fix typo 2021-12-09 16:53:25 +01:00
Nitish
3047c9afe1
Typo fix in MS SQL documentation (#1242) 2020-12-14 01:04:47 +01:00
Drew Repasky
a76f7e1e8c
typo (#1152) 2020-05-26 21:06:17 +02:00
Dimitri Fontaine
49910027c5 Typo fix in the MySQL default casting rules documentation.
See #1123.
2020-04-03 23:34:53 +02:00
Jeff Fendley
be43a49646
Fix unfortunate typo in Redshift doc (#1075) 2020-03-22 16:42:48 +01:00
Dimitri Fontaine
d8b0bd5145 Allow casting rules to guard on signed data types.
It used to be that our casting rules mechanism would allow for matching
unsigned data types only, and we sometimes have a need to do special
behavior on signed data types.

In particular, a signed bigint(20) in MySQL has the same values range as a
PostgreSQL bigint, so we don't need to target a numeric in that case. It's
only when the bigint is unsigned that we need to target a numeric.

In passing update some of the default casting rules documentation to match
the code.

Fix #982.
2019-06-04 15:22:25 +02:00
Dimitri Fontaine
2b6fb3e6c2 Add a casting rule for the I data type in DBF files.
The I data type is mapped to a PostgreSQL integer.

See #929.
2019-05-08 23:36:17 +02:00
Mathieu Santostefano
6aa42ec68f Remove invalid WITH default option (#960)
It seems like `create schema` option for WITH statement is invalid.
2019-05-07 23:06:02 +02:00
Dimitri Fontaine
7b10fabd94 Update DB3 documentation to include user-defined casting rules.
See #927, #938.
2019-04-14 21:56:04 +02:00
Dimitri Fontaine
2147a1d07b Implement ALTER TABLE ... SET TABLESPACE ... as a pgloader clause.
This allows creating tables in any target tablespace rather than the default
one, and is supported for the various sources having support for the ALTER
TABLE clause already.
2019-01-08 22:50:24 +01:00
Dimitri Fontaine
44514deaa7 Improve ALTER TABLE documentation. 2019-01-08 22:09:13 +01:00
Dimitri Fontaine
2cafa8360c Document newly added MATERIALIZE VIEWS for new sources.
Now it's possible to use this clause with a PostgreSQL or an MS SQL database
source.

Fixes #817.
2018-12-19 10:51:04 +01:00
Dimitri Fontaine
007003647d Improve Redshift support documentation. 2018-12-14 18:21:34 +09:00
Dimitri Fontaine
b6de8f1ead Improve Citus documentation. 2018-12-12 09:34:05 +09:00
Dimitri Fontaine
56d24de67a Update documentation with new features.
We have a lot of new features to document. This is a first patch about that,
some more work is to be done. That said, it's better than nothing already.
2018-12-11 14:25:08 +09:00
alexknips
5ca3ee8aad Fix documentation of default MySQL cast rules (#815)
The default rule is `type int to bigint    when  (>= 10 precision)`.
2018-07-20 14:38:06 +02:00
Björn Häuser
ad7ce4a66b Fix documentation for binary datatype changes (#801)
When reading http://pgloader.readthedocs.io/en/latest/ref/mysql.html I came across the section of binary. On the documentation the indentation is off and is kinda hard to read :)
2018-05-26 13:54:28 +02:00
Dimitri Fontaine
cb9e01f4d9 Code review for previous commit.
See #771.
2018-03-27 14:55:31 +02:00
Dimitri Fontaine
e4dca1a086 Implement support for MySQL useSSL=true|false option.
The MySQL connection string parameter for SSL usage is useSSL, so map an
option name to our expected values for sslmode in database connection
strings.

See #748.
2018-03-16 16:41:40 +01:00
Denis Ivanov
a7fd776ecd Update mssql.rst (#762)
Typo in like word
2018-03-13 17:08:51 +01:00
Dimitri Fontaine
20d7858e27 Implement SQLite casting rule for “decimal”.
Fix #739.
2018-02-07 20:47:47 +01:00
Dimitri Fontaine
81be9ae60e Implement support for \' as the CSV separator.
The option "fields optionally enclosed by" was missing a way to easily
specify a single quote as the quoting character. Add '\'' to the existing
solution '0x27' which isn't as friendly.

See #705.
2017-12-26 21:04:06 +01:00
Dimitri Fontaine
25c79dfebc Switch the documentation to using Sphinx.
The website is moving to pgloader.org and readthedocs.io is going to be
integrated. Let's see what happens. The docs build fine locally with the
sphinx tools and the docs/Makefile.

Having separate files for the documentation should help ease the maintenance
and add new topics, such as support for Common Lisp Hackers level docs,
which are currently missing.
2017-12-21 17:45:09 +01:00