Menu
I issue a query in pgAdmin and then want to export the result to a file. How can I specify that the column separator should be a tab character?
281
Step 1: Visit your schema section and select the table you wish to export. Step 2: Right-click on the table name to show up the available options. Step 3: Select the “Import/Export” option. When you click on it, the export data pgAdmin window will appear.
From the query editor, once you have executed your query, you just have to click on the "Download as CSV (F8)" button or use F8 key. Show activity on this post. Use absolute paths or cd to a known location so that you can ignore the path. For example cd into documents directory then run the commands there.
In PgAdmin 4 simply press F8 button to export the data to excel CSV file or click on download button provided in application.
This comes probably too late for you, but maybe not for others.
You can copy / paste a literal tab character into the (dropdown) text box for "Column separator", like any other valid character, and it will be used. Just tested successfully with pgAdmin 1.14.2.
136
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
