Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Copying Postgres Output into a Spreadsheet

DZone's Guide to

Copying Postgres Output into a Spreadsheet

I often need to grab information from a Postgres database and paste it into a spreadsheet for sharing with others

· Database Zone ·
Free Resource

Download the Altoros NoSQL Performance Benchmark 2018. Compare top NoSQL solutions – Couchbase Server v5.5, MongoDB v3.6, and DataStax Enterprise v6 (Cassandra).

I often need to grab information from a Postgres database and paste it into a spreadsheet for sharing with others. Google Sheets needs the pasted data to be tab-separated in order to be correctly split into columns. This isn't the default behaviour for psql but here's how to configure psql's output to get it.

At a psql prompt, switch to unaligned output:

=> \a

and set the field separator to a tab character:

=> \f '\t'

then the output from subsequent SELECT ... statements can be cleanly pastedinto your Google Doc.

Download the whitepaper, Moving From Relational to NoSQL: How to Get Started. We’ll take you step by step through your first NoSQL project.

Topics:
database ,sql ,postgres

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}