Can anyone tell me the sql that is being sent to the database when typeing
this command? I am working on writing some code that will show a list of columns
in a table. Is there a describe statement?
Thanks
Jodi Kanter
___Jodi
L KanterBioInformatics Database Admin
Dong Meng writes:
> Authoriztion switches are specified as above, but what should I do if
> I want to grant 'update' without 'delete' to some table/view?
Wait for release 7.2.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP
-Forwarded Message-
From: Radu-Adrian Popescu <[EMAIL PROTECTED]>
To: Jodi Kanter <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] \d command
Date: 22 Jan 2002 18:05:19 +0200
With debugging enable and tailing log/pgsql, here it is :
SELECT c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'ta
Jodi Kanter wrote:
> Can anyone tell me the sql that is being sent to the database when
> typeing this command? I am working on writing some code that will show a
> list of columns in a table. Is there a describe statement?
>
> Thanks
>
> Jodi Kanter
Start up psql with the -E switch. It wil
On Tue, 22 Jan 2002, Jodi Kanter wrote:
> Can anyone tell me the sql that is being sent to the database when
> typeing this command? I am working on writing some code that will show
> a list of columns in a table. Is there a describe statement?
start psql with the -E option and it'll show you t
Eddy,
The command you need is:
psql> grant update on table_name to username;
Banghe
Dong Meng wrote:
> Dear Guys,
>
> May I have a question about the authorization of psql?
>
> By using '\z' in psql context, I can get the description of authorization about each
>table/view.
>
>
>
