Export Postgresql table data using pgAdmin

1. Right-click on your table and pick option Backup..
2. On File Options, set Filepath/Filename and pick PLAIN for Format
3. Ignore Dump Options #1 tab
4. In Dump Options #2 tab, check USE INSERT COMMANDS
5. In Dump Options #2 tab, check Use Column Inserts if you want column names in your inserts.
6. Hit Backup button

Edit: In case you are using pgAdmin on a remote server: Once the UI announces the backup was successful, you might want to download the data. For this, follow these steps:

1. Click on Tools (in the menu)
2. Select Storage Manager
3. Select the file that was just created
4. Click on the small “Download File” button