sh to remove postgresql headers from csv

[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?

[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!

[Watael]

hi,

sql client may have formatting options.
check man page.