PG Admin 4 how to set pipe delimited export (1 Viewer)

[thenoisydrum]

Hello everyone,
I have been using PG Admin 3 to run SQL queries and then exporting the results as pipe delimited text files. I'm now using PG Admin 4 (through no choice of my own) and the layout is very different. I can only see how to export my queries as a csv. When I say export, I mean download to my desktop.

Here is my current view;

Can anybody help me to select to export this as a pipe delimited text file please?

Many thanks

 

[Minty]

Apparently, you can set a delimiter of your choice - see here;

Import/Export Data Dialog — pgAdmin 4 8.5 documentation

pgAdmin - PostgreSQL Tools for Windows, Mac, Linux and the Web

www.pgadmin.org

 

[thenoisydrum]

Thanks Minty but I cannot see how to get to these options?

 

[Minty]

It looks like they appear when you start the export, sorry I use SSMS but did play with this a few times, but beyond that not much experience with it.

 

[thenoisydrum]

Ok thanks, can anybody else help please?

 

[thenoisydrum]

It's in File>Preferences......

Cheers

Andrew

 

[Minty]

Glad you sorted it out.