Re: [SQL] [ADMIN] Postgres Array Traversing Problem

2007-10-05 Thread Dawid Kuroczko
On 10/4/07, yogesh <[EMAIL PROTECTED]> wrote: > Hello Friends, > > I have a Problem in Accessing Arrays in the Postgres. > The Description of my problem is given > here:--- > I have two array of numeric types. One That stores the IDs and Other > Store their va

[SQL] pg_dump question

2007-10-05 Thread Judith
Hello every body!! I have a quesyion respect pg_dump... I need to backup the db structure, I suposse that I do with pg_dump -s, but I want to restore but just with some tables with the db catalogues, can I do this?, I mean, restore al the db structure without data and after restor

Re: [SQL] pg_dump question

2007-10-05 Thread Erik Jones
On Oct 5, 2007, at 11:58 AM, Judith wrote: Hello every body!! I have a quesyion respect pg_dump... I need to backup the db structure, I suposse that I do with pg_dump -s, but I want to restore but just with some tables with the db catalogues, can I do this?, I mean, restore al

[SQL] valid query runs forever?

2007-10-05 Thread Aroon Pahwa
I'm having a strange issue with postgres...I think. I have the following query: GRANT SELECT ON 'tablename' TO 'username'; As far as I can tell, thats a valid query. It works fine when I run it under the psql command line interface and executed against a remote db. When I try and run the sa