On Mon, Jan 25, 2010 at 04:05:57PM +0100, Stefan Schwarzer wrote:
> Guess I'd need to do this as/with postgres user/role.
Yup, or at least somebody with superuser rights. Try "\du" in psql.
> But really not
> sure how this goes. Thought it should be something like this:
>
> sudo su - postgres -c '/usr/local/pgsql/bin/pgsql' < tablefunc.sql
>
> But that's no correct.
Looks about right, what do you get back?
The following does basically the same thing, but I find it a bit easier
to follow:
sudo -u postgres /usr/local/pgsql/bin/pgsql < tablefunc.sql
--
Sam http://samason.me.uk/