It could help me, but pg_dump give all foreigns key and index creation. I'm not sure if it's not better to write a custom function in plpgsql. Bruno
----- Original Message ----- From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Bruno Prévost" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 16, 2004 11:13 AM
Subject: Re: [SQL] Table definition
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/
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
