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 playing with pgadmin and wireshark trying to > figure out what commands or queries it is using to no avail.
Fire up psql -E and do a few \d commands. It'll show you the SQL used to describe the objects. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general