format output of an sql query

Question

I am attempting to run an sql query and its output was previously formatted in sqlplus but now I am trying to format it in Postgres and I do not know how to do it. Here is how it was previously formatted in sql plus but I have commented out the formatting statements

/** Contains sql script used to generate the Earth orientation data verification report**/


/*set pagesize 66 
set linesize 75

ttitle center EarthOrientation Parameters(U) 
2                                                  

column year heading "Year" format 9999
column month heading "Month" format 99
column day heading "Day" format 99
column mjd heading "MJD" format 99999
column xaxisrotation heading "x(arcsec)" format 99.9999
column yaxisrotation heading "y(arcsec)" format 99.9999
column ut1utcdelta heading "UT1-UTC(sec) format 9.99999*/

\o /h/USERS/local/Palito/results.log   

SELECT *  FROM TB_EARTHORIENTATIONPARAMETER order by earthorientationparameterid; 

\o

I have looked online but all I can find is the syntax for setting the title, column and other things but all I can find is SQLPlus syntax. please assist me with this issue if anyone has knowledge of this.

I had to do a web search to discover what sqlplus was -- it is an Oracle report generation utility to format query results. I'm not sure which report generation utility would be most useful for someone moving from Oracle to PostgreSQL. (Just adding this note to help save others time when trying to respond to the question.) — kgrittn
– kgrittn, Commented Aug 7, 2012 at 16:01

leonbloy · Accepted Answer · 2012-08-07 17:06:22Z

2

now I am trying to format it in Postgres

Postgres (actually PostgresSQL) is the server, it's not an application. You surely mean psql, which is the default terminal client program.

psql does not offer such formatting capabilities, for each column of a query. It just supports the default formatting, together with a "expanded table formatting mode" (\x) (one line per field, and a HTML output format (see docs).

Of course, you can just format each field in the SELECT itself, with the several to_char() formatting functions.

answered Aug 7, 2012 at 17:06

leonbloy

76.4k22 gold badges149 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

format output of an sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related