it sounds like you are missing the contrib code. if you built from source you need to go to the contrib directory and run make, make install.
if you installed from a package you need to install the appropriate contrib package. reiner sent by smoke signals at great danger to my self. On 10 okt 2013, at 14:42, Thara Vadakkeveedu <thar...@yahoo.com> wrote: > Hi > I have postgresql 9.2 installed on red hat linux 6.4 . I need to generate > uuids using the uuid_generate_v4() function. > > select * from pg_available_extensions does not list this extension. The only > extension that is available is plpgsql. > > I find uuid libraries, libuuid.so.1 and libuuid.so.1.3.0 in /lib64 folder. > > What should I do next ? How can I can install this extension ? > > Thanks, > Thara.
