Re: Getting source code for database objects

From: Klint Gore <kgore4(at)une(dot)edu(dot)au>
To: Artacus <artacus(at)comcast(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting source code for database objects
Date: 2008-07-09 04:36:56
Message-ID: 48744068.7000000@une.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
>
>
See GetSql method of schema/*.cpp

This used to be on the list of possible PG projects for the google
summer of code but seems to have been removed.

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4(at)une(dot)edu(dot)au

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2008-07-09 04:42:58 Re: Quick way to alter a column type?
Previous Message Alvaro Herrera 2008-07-09 04:02:02 Re: Getting source code for database objects