Sure. The system tables can be accessed via SQL.
I frequently use the output of psql's hidden queries to glean more
information about postgres internals for needs like yours where
postgres has the information but not the interface to accomplish a
specific task.
-tfo
On Oct 19, 2004, at 12:50 PM
On Tue, 19 Oct 2004 00:48:34 -0500, Thomas F. O'Connell
<[EMAIL PROTECTED]> wrote:
> Ah, yes. You're right.
>
> Presumably you could use the hidden query from \dn in psql to get the
> tables necessary for a script. That's the next best thing I can think
> of.
I wrote a script to do the vacumming.
Ah, yes. You're right.
Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.
-tfo
On Oct 18, 2004, at 6:02 PM, Josh Close wrote:
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
<[EMAIL PROTECTED]> w
On Mon, 18 Oct 2004 15:35:53 -0500, Thomas F. O'Connell
<[EMAIL PROTECTED]> wrote:
> Are you looking for something different than vacuumdb?
>
> http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
>
> -tfo
I think so. As far as I can tell, you can either vacuum a whole db, or
individual t
Are you looking for something different than vacuumdb?
http://www.postgresql.org/docs/7.4/static/app-vacuumdb.html
-tfo
On Oct 18, 2004, at 3:23 PM, Josh Close wrote:
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?
-Josh
---(end of
Is there a way to vacuum all tables in a schema? Or will I need to
write a script to do it?
-Josh
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
