[GENERAL] How could I find the last modified procedure in the database?

2011-11-16 Thread Dhimant Patel
I have postgres *(PostgreSQL) 9.0.3 running.* I also created several procedures/functions and now I don't remember the last procedure I worked on! - I thought I could always get this from metadata. Now I'm stuck - couldn't find this details anywhere in catalog tables! Is there anyway I can get th

[GENERAL] pg_database_size(oid)

2010-02-17 Thread Dhimant Patel
Hi All, I have just started with postgres and after going through manual nearly for 2 hours, I need help. I have created a database, which I plan to load with several tables. I am trying to find the size of the databases and came across pg_database_size(oid) function. Since it requires databse oi

[GENERAL] Currently connected users...

2010-01-21 Thread Dhimant Patel
I'm a beginner Postgres user, and need quick hint from someone. How could I know which users are currently connected to postgres instance? Thanks, DP.