Skip site navigation (1) Skip section navigation (2)


From: "Usama Munir" <usama(dot)munir(at)enterprisedb(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_get_tabledef
Date: 2007-05-21 13:20:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
Hi, <br>
i was following a thread some time ago where adding a function <b>pg_get_tabledef</b>
was one of the TODOs for 8.2, but it somehow didn't make it to the
release perhaps because the functionality was not clearly defined? not
Anyway&nbsp; i happen to come up with a function for pg_get_tabledef which
works something like following<br>
<i>postgres=# select pg_get_tabledef(16388) ;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pg_get_tabledef&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
&nbsp;CREATE TABLE&nbsp; public.dept<br>
&nbsp; deptno numeric(2,0) NOT NULL,<br>
&nbsp; dname&nbsp; character varying(14),<br>
&nbsp; loc&nbsp;&nbsp;&nbsp; character varying(13)<br>
&nbsp;WITHOUT OIDS;<br>
</i>(1 row)<br>
i wanted to submit a patch for this, IFF the community wants this
function. The rationale is obviously to help Application developers
writing applications like pgAdmin. Currently this part of SQL needs to
be constructed manually for postgres by the tools.<br>
it is arguable that a table defintion will have constraints , triggers
etc as well, and they can be added without much problem, but i think if
a tool needs to construct an SQL for all table related objects then
functions are already available for them like pg_get_constraintdef,
pg_get_ruledef, pg_get_indexdef, pg_get_triggerdef etc<br>
i understand that you guys don't like someone to develop a patch in
isolation and just come up with it one day, but it really came out as a
by-product of some other work , and i thought you guys might be
interested in it.<br>
if it is desired,&nbsp; i will submit&nbsp; a patch for it, within a day or so.<br>
Usama Munir<br>
EnterpriseDB (<a class="moz-txt-link-abbreviated" href=""></a>)<br>

Attachment: unknown_filename
Description: text/html (2.1 KB)


pgsql-hackers by date

Next:From: Gregory StarkDate: 2007-05-21 13:21:50
Subject: Re: Concurrent psql patch
Previous:From: Magnus HaganderDate: 2007-05-21 11:18:27
Subject: Re: mb and ecpg regression tests

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group