Hi all,
Having had a play with GRANT, REVOKE and database ownership, a couple of
things have come to my attention. I'm pretty sure I've covered everywhere
these may be explained in the documentation, but please send me off in the
right direction if I've missed something:
1) There doesn't seem to
> will trillich <[EMAIL PROTECTED]> wrote:
>
> >Care to explain -- in terms a Debian newbie might grok -- what
> >"contrib/pgcrypto" means?
>
> Peter is referring to a directory in the PostgreSQL sources, not to a part
> of a binary package. "apt-get source postgresql" and look around.
You'll
> Use the "tableoid" pseudo-column.
Ah! Awesome.
A little playing with pg_class, and we have table/class names too.
PostgreSQL has cool new things to find every day...
Thanks Tom!
- Jeff
--
Web development with PHP is like injecting pure rust with a
hig
Hi all,
Is there a way of determining the original class of a row when querying
inherited tables? Consider:
CREATE TABLE users (
uid int4 SERIAL PRIMARY KEY,
email varchar(60)
);
CREATE TABLE clients (
surname varchar(30)
[etc]
) INHERITS (users);
CREATE TABLE suppliers (
> should not be more than three persons. And since this is Linux, once the
> system is up and running, all administration can be done via telnet.
s/telnet/ssh/
Using telnet is like dropping your spare key outside the security shield
every time you go in. :)
- Jeff
-- excuse the email softwar
> Bruce Momjian wrote:
>
> Hey, we didn't design SQL, we just implement it. :-)
Oh, that's quotable... ;)
- Jeff
-- [EMAIL PROTECTED] - http://linux.conf.au/ --
linux.conf.au - coming to Sydney in January 2001
Installing Linux Around A
> Byron Nikolaidis wrote:
>
> How about links to all the other front-ends, like the odbc and jdbc drivers
> for example? I know there are plenty more front-ends and useful things
> that should appear in some kind of "links" section or something.
>
> This seems not so good to me. Is it that h
