Обсуждение: mysql_field_name equivalent
Is there a PostgreSQL equivalent command to the mysql_field_name command above? I am running a select query (7.2) and would like to get the name of the columns I am selecting too, in order to output a header line to an external file, with the result of the select. Has anyone done this or similar? Thank you. Richard Mace ********************************************************************** The information contained in this email is confidential and is intended for the recipient only. If you have received it inerror, please notify us immediately by reply email and then delete it from your system. Please do not copy it or use itfor any purposes, or disclose its contents to any other person or store or copy this information in any medium. The viewscontained in this email are those of the author and not necessarily those of Lorien plc. Thank you for your co-operation. **********************************************************************
On Dec 31, 2003, at 5:59 AM, Mace, Richard wrote: > I am running a select query (7.2) and would like to get the name of > the columns I am selecting > too, in order to output a header line to an external file, with the > result of the select. I'm not familiar with the mysql command mentioned, but just using \o and specifying a file in psql does what it sounds like you want. Specify the file using: \o /path/to/results.txt The result of every query entered through psql will appear in the file just as it would otherwise in psql, complete with column headings. There are ways to specify the delimiter (e.g., tabs rather than spaces), or the border (and other options as well) using /pset Does this help? Michael Glaesemann grzm myrealbox com
Hi, Mace, Richard wrote, On 12/31/2003 12:59 PM: > Is there a PostgreSQL equivalent command to the mysql_field_name command above? > > I am running a select query (7.2) and would like to get the name of the columns I am selecting > too, in order to output a header line to an external file, with the result of the select. > > Has anyone done this or similar? you probably want this from php. Better to use, ask at comp.databases.postgresql.interfaces.php for php related questions. try the php documentation and check: pg_field_name C.