using windows batch file I Executed a postgres select query, I need only the data(value alone) as output?

Question

For my select query:

SELECT pg_size_pretty(pg_total_relation_size('tablename'))

It returns result like following.

pg_size_pretty
 -----------
    24 kB
   (1 row)

I need only 24 kB as output.

I don't really understand what's the question here. Please clarify. — bahrep
– bahrep, Commented Oct 16, 2012 at 13:01

Craig Ringer · Accepted Answer · 2012-10-16 13:39:46Z

1

Use the --tuples-only flag to psql:

psql databasename --tuples-only -c "SELECT pg_size_pretty(pg_total_relation_size('tablename'));"

answered Oct 16, 2012 at 13:33

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

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

1 Answer 1