Withdata Software

Import TXT (pipe delimited text) into PostgreSQL

Shiji Pan

Want to import data from TXT (“|” pipe delimited text) file to PostgreSQL?

Try Withdata FileToDB, a desktop TXT to PostgreSQL converter for Windows, MacOS, and Linux, Convert TXT to PostgreSQL, Easy and Fast.

Download Withdata FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import data from TXT (“|” pipe delimited text) file to PostgreSQL

Login to PostgreSQL -> Choose TXT file -> Set PostgreSQL table -> Import TXT to PostgreSQL

Choose PostgreSQL and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select the “TXT” file type.

then show the wizard.

1. Open a TXT (“|” pipe delimited text) file.

Support large ( > 4GB ) TXT file.

Here is the file’s content.

2. Select a PostgreSQL table and config fields.

3. Preview data will be in PostgreSQL table.

4. Import TXT data to PostgreSQL.

View imported data in PostgreSQL table

Import TXT to PostgreSQL in command line

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

Set scheduled tasks for importing TXT to PostgreSQL

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

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “TXT to PostgreSQL” conversion.
  2. Set scheduled task for “TXT to PostgreSQL” conversion.

FAQ

What is Withdata FileToDB?

Withdata FileToDB is an ETL software can import TXT (“|” pipe delimited text) data to PostgreSQL. Download Withdata FileToDB

How long does it take to import TXT (“|” pipe delimited text) data to PostgreSQL?

FileToDB works fast. It convert millions of rows within a minute.

Is it safe to import TXT (“|” pipe delimited text) data to PostgreSQL using FileToDB?

Of course! FileToDB import TXT (“|” pipe delimited text) data to PostgreSQL locally, absolutely safe.

Can I import TXT (“|” pipe delimited text) data to PostgreSQL on Linux, Mac OS?

Yes, you can. FileToDB has Linux, Mac OS, and Windows version.

Can I import TXT (“|” pipe delimited text) data to PostgreSQL in command line?

Yes, you can. FileToDB can running in command line, on Linux, Mac OS, and Windows.

More about Withdata FileToDB – TXT (“|” pipe delimited text) to PostgreSQL converter

See also: