Show confirmation prompt for dropping the table if and only if a table exists

[rodrigo-morales-1]

This is a feature request.

The current behavior is that a confirmation prompt is shown whenever the script is used. I think that it would be less redundant if the confirmation prompt were shown if there exists a table in the specified schema.

I think that this behavior can be changed by adding a conditional that checks if a table exists in the specified schema in the following part of the code (specifically, where choice is).

stackexchange-dump-to-postgres/load_into_pg.py

Lines 391 to 401 in 49d8358

	# load given file in table
	if args.file and args.table:
	table = args.table
	if table == "Posts":
	# If the user has not explicitly asked for loading the body, we replace it with NULL
	if not args.with_post_body:
	specialRules[("Posts", "Body")] = "NULL"
	choice = input("This will drop the {} table. Are you sure [y/n]?".format(table))
	if len(choice) > 0 and choice[0].lower() == "y":

I think doing this is necessary for making the script fully scriptable since the current behavior requires the interaction of the user or some workaround for automating it.