Export PostgreSQL table to TXT with GUI tool

by

Posted on by

Want to export data from PostgreSQL table to TXT file?

Using Withdata DB To File, a TXT exporter for PostgreSQL on Windows, MacOS, and Linux, you can export PostgreSQL data to TXT file easily and fast.

Download DBToFile Download DBToFile

Export data from PostgreSQL table to TXT file

Login to PostgreSQL -> Choose PostgreSQL table -> Set TXT file options -> Export PostgreSQL to TXT

Choose PostgreSQL and logon.

export PostgreSQL table to TXT file - Choose PostgreSQL and logon

“Export From Table” for “PostgreSQL to TXT”.

Export data from PostgreSQL Table To TXT File - task window

Select TXT file type.

Export data from PostgreSQL Table To TXT File - select TXT file type

1. Choose PostgreSQL table.

Unload data from PostgreSQL Table To TXT File - select table

2. Set TXT file options.

You can set “Delimiter” to:

  • “,” : for exporting PostgreSQL to comma separated text file
  • “TAB” : for exporting PostgreSQL to tab separated text file
  • “|” : for exporting PostgreSQL to pipe separated text file
  • “;” : for exporting PostgreSQL to exporting PostgreSQL toor semicolon separated text file
  • “#” : for exporting PostgreSQL to hash tag separated text file
  • “WHITESPACE” : for exporting PostgreSQL to whitespace delimited text file

Extract data from PostgreSQL Table To TXT File - enter file name

3. Summary.

Convert data from PostgreSQL Table To TXT File - summary

4. Export PostgreSQL data to TXT file.

Dump data from PostgreSQL Table To TXT File - export

After exporting, you can view output TXT files.

Export data from PostgreSQL Table To TXT File - view TXT file

Export PostgreSQL to TXT in command line

Save “PostgreSQL to TXT” session, then you can:

Set scheduled tasks for exporting PostgreSQL to TXT

You can schedule and automate this “PostgreSQL to TXT” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file.
  2. Set scheduled task.

FAQ

More about DBToFile – PostgreSQL to TXT converter