Hi !
I have 2 base Ex: base1 and base2
When I connected to base1 I need data from base2 !
How did this without disconect from base1 and connect to base2
agregate all table into one databese not accesable
In mysql this is posible.
Red
---(end of broadcast)
Hello,
I' m currently working with the PHPDOC team on maintaining and
keeping up-to-date the PHP manual. I proposed in the PHPDOC
list to include some information about database security issues.
It aims to be an introduction into the very basics of how to
access and manipulate databases
Jodi Kanter writes:
> I am working with a database that was not created by our team. There are
> some indexes set up on a table and I need to understand what type they are
> and how they are functioning.
> How can I look at this in Postgres?
\d tablename or \d indexname in psql.
--
Peter Eisen
Jodi Kanter writes:
> Can I grant a user all privileges to all the tables without having to type a
> grant command for each table individually?
No. Sorry.
Typing can be automated, of course.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)--
I should have just given you this example in my earlier reply- this is how I
quickly get a batch of grant statements- you can probably modify it for your
needs:
select 'grant select on '||relname||'to "www-data";' from pg_class where
relname not like 'pg%';
-Nick
> -Original Message-
There's no command to essentially grant on all to a user, but it's
pretty easy to write a select that produces a bunch of grant statements for
you based on the system tables. then you log the results & run them...
-Nick
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PRO
This my be simpler than the answer you were after, but...
If you're getting something like "cannot insert duplicate key into unique
index fred", you could type: "\d fred" at a psql prompt to learn what
column(s) fred refers to. You can learn even more by digging into the system
tables, but I'll l
I am working with a database that was not created by our team. There are
some indexes set up on a table and I need to understand what type they are
and how they are functioning.
How can I look at this in Postgres?
I have a situation where we trying to update data and are receiving an error
based o
Can I grant a user all privileges to all the tables without having to type a
grant command for each table individually?
I know that I can use:
grant all on object to username
but I would like to set this person up as a superuser for now so that he can
assist with development.
It appears that wh
