pgloader mysql to Postgres command line exclude table

62
February 11, 2019, at 06:00 AM

I have the following command that works.

pgloader --root-dir /tmp/ --with "batch rows = 500" --cast "type datetime to timestamp drop not null using zero-dates-to-null" --cast "type tinyint to smallint drop typemod" --cast "type timestamp to timestamp drop not null using zero-dates-to-null" --cast "type enum to varchar" --cast "type char to varchar" --cast "type date to date drop not null using zero-dates-to-null" mysql://XXXXX:YYYYY@127.0.0.1/test postgresql://XXXXX@127.0.0.1:5432/test

Is there an option to exclude a table?

Thanks

READ ALSO
Phpmyadmin, I want to restore the backup of the databases

Phpmyadmin, I want to restore the backup of the databases

I've gone and reviewed all the databases and I chose the export option in phpmyadmin and he collect all the databases in one file now I want to restore this filePhpmyadmin Say Select Database

46
How can I select from the same table with different where conditions and differnet group by conditions in this case?

How can I select from the same table with different where conditions and differnet group by conditions in this case?

Basically this is what I am trying to achieve but I don't know how to do it in a single query, I don't know if it can be done in a single query

34
Calculate the average number of hours in table per month

Calculate the average number of hours in table per month

I have a table named "loginhistory", and I need to calculate the most active hour of the monthHow can i do it?

33
follower/following relationship

follower/following relationship

I understand how basic database relationships work but I am confused about the following/follower social media relationship in RDBMs

47