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, Josh Close wrote:
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. I just have a config file where you can list the tables you want vacuumed.
Can you use those tables via normal sql? It would be nice to do that via sql.
-Josh
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html