--- Doug Moore <[EMAIL PROTECTED]> wrote: > Hi, > > As I understand it, in order to read in a file containing sql > commands > I should use the \i <file> syntax in psql. > > So, from the psql prompt I type: > > \i /root/phones > > I get back "/root/phones: permission denied" > > I am in psql as the user who owns the database. > The file in question is readable and writeable by all. You have given rights for everyone on your machine to read/write to the /root directory? Enter the /root directory and run this (if 'phones' is the sql file): % psql -f phones Brent __________________________________________________ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
