jan-peter.seif...@gmx.de writes:
> Hello raf,
>>> Easier is just
>>> select oid::regprocedure from pg_proc where
>> note that this method doesn't produce a complete function
>> signature. the precision and scale of numerics are not
>> included in the output. hopefully, that won't matter for
>> yo
Hello Tom,
> > I combined your suggestions into this query I'll be using for now:
>
> > SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM
>
> This is flat *wrong*, as you'll soon find if you are working with
> functions in more than one schema. regprocedure already puts a
> sch
Hello raf,
> > > Easier is just
> > > select oid::regprocedure from pg_proc where
> note that this method doesn't produce a complete function
> signature. the precision and scale of numerics are not
> included in the output. hopefully, that won't matter for
> your needs.
Oh. So functions expe
jan-peter.seif...@gmx.de wrote:
> Hello Ashish, Hello Tom,
>
> thank you very much for your quick and helpful replies - I really appreciate
> that.
>
> > > May be this will help you:
> >
> > Easier is just
> > select oid::regprocedure from pg_proc where
>
> I guess I'll go with the very
jan-peter.seif...@gmx.de writes:
> I combined your suggestions into this query I'll be using for now:
> SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM
This is flat *wrong*, as you'll soon find if you are working with
functions in more than one schema. regprocedure already put
Hello Ashish, Hello Tom,
> > before I reinvent the wheel I'd like to know whether there's a shortcut
> for getting the 'full' name (incl. argtypes) of the functions within a
> database in order to REVOKE priviliges on them given to certain users.
I combined your suggestions into this query I'll b
Hello Ashish, Hello Tom,
thank you very much for your quick and helpful replies - I really appreciate
that.
> > May be this will help you:
>
> Easier is just
> select oid::regprocedure from pg_proc where
I guess I'll go with the very nifty type cast suggested by Tom though as this
cove
Ashish Karalkar writes:
> Jan-Peter Seifert wrote:
>> Obviously you can't just use the specific_name from
>> information_schema.routine_privileges for this.
> May be this will help you:
Easier is just
select oid::regprocedure from pg_proc where
regards, tom lan
Jan-Peter Seifert wrote:
Hello,
before I reinvent the wheel I'd like to know whether there's a shortcut for
getting the 'full' name (incl. argtypes) of the functions within a database in
order to REVOKE priviliges on them given to certain users.
I don't see anything in the docs:
http://www.po
Hello,
before I reinvent the wheel I'd like to know whether there's a shortcut for
getting the 'full' name (incl. argtypes) of the functions within a database in
order to REVOKE priviliges on them given to certain users.
I don't see anything in the docs:
http://www.postgresql.org/docs/8.3/inter
10 matches
Mail list logo
