Import data - Table Doesn't function properly

[jayparkertech]

Please note that security bugs or issues should be reported to [email protected].

Describe the bug

When you create a blank table and then attempt to use the import/export data function to populate the table, it fails and throws the error:
(Columns) indicating you need to select columns.

To Reproduce

Steps to reproduce the behavior:

1. Select the table you wish to import to
2. right click and select the import/export function
3. First, when you initially open the dialog it defaults to import, and it allows you to select the file, format and encoding under the general tab. The options tab appears fine, but then when you get to the columns tab it still dsiplays "select which columns to 'export'" NOT 'import' as it should display.
4. To get it to request the columns to import you have to go back to the general tab, change it from import to export and then back to import, which by the way erases your previous file selection, but you can then select the file, format and encoding again, then when you go to the columns tab, it correctly displays "select columns to import,"
5. however when you click in the drop down it says "no items for selection."
6. The help for this function says that no selection causes all columns to be imported, however this does not work. when you click ok to begin the import it throws the error:
7. See Error "! 'Columns' " in a red dialog box at the bottom of the window and does not proceed.

Expected behavior

I expect it to import the data from the csv or other file into the table without column selection as described

Error message

If possible, include the full, unedited text of any error messages displayed.

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: windows 11
• Version: 11
• Mode: Desktop
• Browser chrome
• Package type: python venv

[pravesh-sharma]

Hi @jayparkertech,

Can you please share the pgAdmin version?