Re: [SQL] Documenting a DB schema

2008-03-05 Thread Professor Flávio Brito
Hi You may try this. CREATE TYPE tabela_estrutura AS (esquema text, tabela text, campo text, tipo text, valor text, autoincremento boolean); ALTER TYPE tabela_estrutura OWNER TO postgres; CREATE OR REPLACE FUNCTION dados_tabela(character varying) RETURNS SETOF tabela_e

Re: [SQL] Documenting a DB schema

2008-03-04 Thread Steve Crawford
Shahaf Abileah wrote: I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recomme

Re: [SQL] Documenting a DB schema

2008-03-04 Thread Emi Lu
Hi, I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? I am usi

[SQL] Documenting a DB schema

2008-03-04 Thread Shahaf Abileah
I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? It would be g