Thread: how to see a trigger

hi, I have a trigger. It is created by CREATE TRIGGER ... How can I see how it is defined? I know of a table pg_trigger but there's no useful information in it (at least to me). Is dump the only solution? Or maybe there is a special pgsql command to do this? My second question. When I create a foreign key there are triggers created. How exactly they are defined? And the last one. What is the command (in pgsql) to alter a table (say table A) in such a way that it has a foreign key (refering to some table B)? I will appreciate any help, thanx. -- Lukasz Sacha

hi all,
    can anybody tell me the password of postgres user in RH linux
7.2. The pgsql i am using comes as part of the RH linux 7.2.
Right now i am logging as root and using su - postgres to use postgrey.
thanx in advance.

--
regards,
hari

On Fri, 2002-10-18 at 10:03, HK wrote:
> hi all,
>     can anybody tell me the password of postgres user in RH linux
> 7.2. The pgsql i am using comes as part of the RH linux 7.2.
> Right now i am logging as root and using su - postgres to use postgrey.
> thanx in advance.

It ought (I am not a RH user) to be an account which by default cannot
be used directly - i.e. the password field in /etc/shadow should contain
"*" which cannot be matched by anything.  It would be very bad practice
for RH to set a default password for any user.

If you want to be able to log in directly, set a password for it
yourself:

  # passwd postgres

but in my opinion the way you are doing it now is preferable - if
someone were to log in directly as 'postgres', how could you know which
particular individual had logged in?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Delight thyself also in the LORD; and he shall give
      thee the desires of thine heart."          Psalms 37:4