Member Avatar for MCLASS80

I want to output results from a postgresql table into a csv file. I can do this however its also copying over headers and a row count.

Im using \o /path then my sql query;

Is there a way to get rid of the headers so i just have the data?

  • 3 Contributors
  • 2 Replies
  • 128 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Watael
Member Avatar for JeoSaurus

Hi MCLASS80!

Have you got any sample data for us? What are you using to get the dump? Could we see that part of your existing script?

From there, we should be able to help you figure out how to trim out the unwanted stuff.

Thanks!

Member Avatar for Watael

hi,

sql client may have formatting options.
check man page.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.