pgloader
pgloader copied to clipboard
empty table breaks?
trafficstars
- [x] pgloader --version
pgloader version "3.6.2"
compiled with SBCL 2.0.6.debian
-
[ ] did you test a fresh compile from the source tree?
-
[x] did you search for other similar issues?
-
[x] how can I reproduce the bug? postgres is running fine in a local container:
pgloader --type csv --with "drop indexes" --with "fields terminated by ','" --with truncate ./export.csv postgres://postgres:[email protected]:5432/anvil?tablename="csv_todos"results in:
2022-05-09T14:43:18.016000Z LOG pgloader version "3.6.2"
KABOOM!
FATAL error: pgloader found 0 target tables for name csv_todos:
An unhandled error condition has been signalled:
pgloader found 0 target tables for name csv_todos:
What I am doing here?
pgloader found 0 target tables for name csv_todos:
export.csv (utf-8):
"ID","desc","done","user"
"[242374,410726810]","test a",0,"#ROW[242390,410710855]"
the table is created with Adminer:

I expect pgloader to create columns with type according to data, I might be wrong :)