select datid from pg_stat_database where datname='km'; select database_size(that_id); -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Carol Walter Sent: Nov 13, 2007 9:35 AM To: pgsql-admin@xxxxxxxxxxxxxx Subject: Help with command syntax? Greetings, Can someone help me with the syntax for running a postgres function from the within psql? I need to know the size of several databases. The postgres documentation says there is a function that will do what I need. The function is pg_database_size(name). I tried select pg_database-_size(km). The response I get says there is no column "km". I think I must be using the wrong syntax, but haven't found a reference to what the correct syntax is. Thanks, Carol Walter ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
