Re: [GENERAL] system tables...

2006-11-13 Thread Shoaib Mir
I guess pg_class, pg_database and pg_proc can help hereThanks,--Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/13/06, Marko Rihtar <[EMAIL PROTECTED]> wrote: Hi,is there a system table in which postgres stores all data about newlycreated database?together with database objects, tables,

Re: [GENERAL] system tables...

2006-11-13 Thread Richard Huxton
Marko Rihtar wrote: Hi, is there a system table in which postgres stores all data about newly created database? together with database objects, tables, columns, functions etc. Try the manuals under "System Catalogs". -- Richard Huxton Archonet Ltd ---(end of bro

[GENERAL] system tables...

2006-11-13 Thread Marko Rihtar
Hi, is there a system table in which postgres stores all data about newly created database? together with database objects, tables, columns, functions etc. thanks _ FREE pop-up blocking with the new MSN Toolbar - get it now! htt

Re: [GENERAL] System Tables

2001-03-14 Thread Peter Eisentraut
Robert Korteweg writes: > I made a list of all the system tables and there columns in an ascii > file. the only thing i am still missing is the meening of the columns :( > > Q: does anyone already have such a file with explanations to each > column? > Q: does anyone know if there is a more accura

[GENERAL] System Tables

2001-03-14 Thread Robert Korteweg
Hi, I made a list of all the system tables and there columns in an ascii file. the only thing i am still missing is the meening of the columns :( Q: does anyone already have such a file with explanations to each column? Q: does anyone know if there is a more accurate overview than the one on th

[GENERAL] System Tables

2001-02-12 Thread Nelio Alves Pereira Filho
Is it possible to accomplish any SQL statement manipulating the System tables? I was wondering about the possibility to substitute the unrecognized SQL statements (ALTER TABLE table COLUMN , for instance) through some queries to the system tables. Nelio -- Nelio Alves Pereira Filho IFX Networ

[GENERAL] System Tables ER / ALTER COLUMN

2001-01-23 Thread Nelio Alves Pereira Filho
I was wondering if there is a ER diagram of the system tables.. As pgsql doesn't have a command to change the type of a field, I thought to make a procedure that do that, changing the system tables. Tks -- Nelio Alves Pereira Filho IFX Networks - www.ifx.com.br +55 11 3365-5863 [EMAIL PROTECTED

Re: [GENERAL] System tables

2001-01-22 Thread Dan Wilson
Descriptions of the system tables can be found here: http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm Also, if you want to muddle through some PHP code, you can get phpPgAdmin and checkout how the database and table structures are retrieved. It's all done with standard queries.

Re: [GENERAL] System Tables Questions

2001-01-02 Thread Peter Eisentraut
Colin Taylor writes: > Hi, > Anyone know where I can get a decent description of the system tables and > their contents? > Thanks in advance, > Colin http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[GENERAL] System Tables Questions

2001-01-02 Thread Colin Taylor
Hi, Anyone know where I can get a decent description of the system tables and their contents? Thanks in advance, Colin

[GENERAL] System tables

2000-04-05 Thread Paulo Jan
Hi all: Is there any document that describes the system tables of Postgres (the pg_* ones), their function, utility, relations among each other, etc., and how can one manipulate them to recover from errors? I am asking this because I've just experienced one of those awful database