Re: Getting source code for database objects - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Getting source code for database objects
Date
Msg-id 20080709040202.GI4095@alvh.no-ip.org
Whole thread Raw
In response to Getting source code for database objects  (Artacus <artacus@comcast.net>)
List 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.

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.

pgsql-general by date:

Previous
From: Artacus
Date:
Subject: Getting source code for database objects
Next
From: "Jonathan Bond-Caron"
Date:
Subject: Feature: FOR UPDATE SKIP LOCKED