Allow user permission to create Database

ALTER USER username CREATEDB;

Case insensitive select

select "x_partnerNumber" from res_partner limit 10

Double quote allows to select the column containing uppercase carachters

Save query to file

psql -h ip_address -U odoo -c "select ********" >> '/path/file.txt'