[GENERAL] piping output to file

2004-02-08 Thread Russ Schneider
Is there an easy way to pipe a select statement's output to a file? -- [ Russ Schneider (a.k.a. Sugapablo) ] [ http://www.sugapablo.com <--music ] [ http://www.sugapablo.net <--personal ] [ [EMAIL PROTECTED] <--jabber IM ] ---(en

Re: [GENERAL] several messages

2004-01-04 Thread Russ Schneider
On Fri, 26 Dec 2003, Russ Schneider wrote: > I need to transfer a dump from a psql 7.3 database to a 7.2 database. > > Is there any way to do this? In case anyone wants to know (or find out later searching the archives), I was able to do this with minimal effort. Here's what

[GENERAL] Change onership of database and all tables?

2003-12-28 Thread Russ Schneider
In 7.2, how would you change ownership of a database and all its tables and sequences? Right now everything is owned by postgres and I want to change ownership to a regualar user. -- [ Russ Schneider (a.k.a. Sugapablo) ] [ http://www.sugapablo.com <--music ] [ h

[GENERAL] dump 7.3 into 7.2?

2003-12-26 Thread Russ Schneider
I need to transfer a dump from a psql 7.3 database to a 7.2 database. Is there any way to do this? -- [ Russ Schneider (a.k.a. Sugapablo) ] [ http://www.sugapablo.com <--music ] [ http://www.sugapablo.net <--personal ] [ [EMAIL PROTECTED] <--