On 02/02/10 09:58, dipti shah wrote:
Techdb=# show hba_file;
hba_file
--------------------------------------
/etc/postgresql/8.4/main/pg_hba.conf
(1 row)
Ah! you're running a Debian-based system by the look of it.
Moreover, is there anyway to view content of this file from stored in above
location "Techdb" command prompt itself.
Techdb=# cat /etc/postgresql/8.4/main/pg_hba.conf;
ERROR: syntax error at or near "cat"
LINE 1: cat /etc/postgresql/8.4/main/pg_hba.conf;
^
You would normally do so from the system shell rather than psql.
However, you can "shell out" with a backslash command in psql:
\! cat /etc/...
You might not have permission to view that file.
A full list of psql backslash commands are available in the manual
(client applications), psql man-page and by doing \? (or \h for sql help).
HTH
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
