Re: Table definition - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Table definition
Date
Msg-id 200411161713.34830.peter_e@gmx.net
Whole thread Raw
In response to Re: Table definition  (Bruno Prévost <bp@interaction.ws>)
List pgsql-sql
Am Dienstag, 16. November 2004 16:40 schrieb Bruno Prévost:
> I need to use it in sql.

There is no direct way to do this in SQL, but I can offer you the following 
alternative:

CREATE FUNCTION get_table_definition(text) RETURNS text AS '
#!/bin/sh
pg_dump -t $1
' LANGUAGE plsh;

:)

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Bruno Prévost
Date:
Subject: Re: Table definition
Next
From: Bruno Prévost
Date:
Subject: Re: Table definition