Re: [GENERAL] Getting source code for database objects

2008-07-09 Thread Tino Wildenhain
Richard Huxton wrote: Artacus wrote: Easier would be just uing pg_dump -s >schema.sql to get all schema objects so you could check them into subversion. If you want only specific objects, pg_dump -l >listofobjects, then edit this list as you like and use pg_dump -L listofobjects >someobjects.

Re: [GENERAL] Getting source code for database objects

2008-07-09 Thread Richard Huxton
Artacus wrote: Easier would be just uing pg_dump -s >schema.sql to get all schema objects so you could check them into subversion. If you want only specific objects, pg_dump -l >listofobjects, then edit this list as you like and use pg_dump -L listofobjects >someobjects.sql The -l and -L opt

Re: [GENERAL] Getting source code for database objects

2008-07-09 Thread Artacus
Easier would be just uing pg_dump -s >schema.sql to get all schema objects so you could check them into subversion. If you want only specific objects, pg_dump -l >listofobjects, then edit this list as you like and use pg_dump -L listofobjects >someobjects.sql The -l and -L options are not reco

Re: [GENERAL] Getting source code for database objects

2008-07-08 Thread Tino Wildenhain
Artacus wrote: On pgadmin, when you click on a table or function, you get the source code (DDL) to create that table or function. I want to take that and check it into subversion so I have one file for each table, function, view, etc. My question is, how do you get that source code? I've been

Re: [GENERAL] Getting source code for database objects

2008-07-08 Thread Klint Gore
Artacus wrote: On pgadmin, when you click on a table or function, you get the source code (DDL) to create that table or function. I want to take that and check it into subversion so I have one file for each table, function, view, etc. My question is, how do you get that source code? I've been

Re: [GENERAL] Getting source code for database objects

2008-07-08 Thread Alvaro Herrera
Artacus wrote: > On pgadmin, when you click on a table or function, you get the source > code (DDL) to create that table or function. > > I want to take that and check it into subversion so I have one file for > each table, function, view, etc. My question is, how do you get that > source cod

[GENERAL] Getting source code for database objects

2008-07-08 Thread Artacus
On pgadmin, when you click on a table or function, you get the source code (DDL) to create that table or function. I want to take that and check it into subversion so I have one file for each table, function, view, etc. My question is, how do you get that source code? I've been playing with pg