Re: [ADMIN] I have elaborated some useful views...

2005-03-02 Thread Greg Patnude
Sweet !!! "Martha Cecilia Ayala "Hernández"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > > I have elaborated some useful views for administration purposes: > > create or replace view pga_functions as >select >l.lanname as language, >n.nspname || '.' || p.pr

Re: [ADMIN] Database Name

2005-03-02 Thread Greg Patnude
"Envbop" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > I've just inherited a PostgreSQL database, for which I do not have any > details of, like database name or the users. > This used to be a library database which was managed via a web page > written > in php. > Its runni

[ADMIN] Procedures, rules & UDF's....

2005-03-01 Thread Greg Patnude
Is there a quick and dirty SQL query where I can locate the rules, procudures and user-defined functions in the system catalogs ??? there ain't a ton of documentation on the pg_catalog tables & view TIA ---(end of broadcast)--- TIP 8: e

Re: [ADMIN] Urgent!!!! Setting permissions on Views

2004-02-17 Thread Greg Patnude
CREATE RULE no_inserts_on_my_view AS ON INSERT TO myView DO INSTEAD NOTHING;   -- Greg Patnude / The Digital Demention2916 East Upper Hayden Lake RoadHayden Lake, ID 83835(208) 762-0762 ""Dani Mezher"" <[EMAIL PROTECTED]> wrote in message news:[EMAI