Re: [SQL] pg_dump/pg_restore question

2004-08-22 Thread Iain
Hi Worik, I can't address the specifics of your problem but I'll give you an example of I do it on a 7.4 db. I dunno if all options are available on your version. To get the backup: pg_dump --format=c -v DBNAME > FILENAME.dump To restore you have to create a new DB (drop the old one first if n

Re: [SQL] only last records in subgroups

2004-08-22 Thread Greg Stark
Dino Vliet <[EMAIL PROTECTED]> writes: > x,0 and y,4 but how do I manage this in sql? I was > hoping for a keyword LAST or so, where I can specify > that when I've ordered my results with order by, I > could only get the last of the subgroups (the first > one is easy because I could use limit 1)

Re: [SQL] sleep function

2004-08-22 Thread Greg Stark
John DeSoi <[EMAIL PROTECTED]> writes: > On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote: > > > I can't think of one, no. I think you will have to use one of the > > server-side languages and call a sleep in there. > > This is no good in the real world since it pounds the CPU, but it worked

[SQL] pg_dump/pg_restore question

2004-08-22 Thread Worik
Freinds I am new to this list, and this is my first message. I hope this is the correct forum, and the question not too stupid/simple. I have a database on a debian stable system... dpkg -l postgresql [snip] ii postgresql 7.2.1-2woody5 Object-relational SQL database, descended fr When I dum

Re: [SQL] reply to setting

2004-08-22 Thread Greg Stark
Joe Conway <[EMAIL PROTECTED]> writes: > This is very true. In fact, I get mildly annoyed when people *don't* include > the direct reply to me, because I very actively filter/redirect my mail. > Replies directly to me are pretty much guaranteed to be seen quickly, but the > ones that go to the li