Обсуждение: How do i get DDL of a Table from system catalog ?

Hi,<br /><br /> How do i get DDL of a Table from system catalog ?<br /><br /> Purpose :<br /> 1) i need to create an
externaltable on the basis of  another table.<br />      create table ext_table (like table_name);
------------------>this doesnot work for external tables.<br /> 2)  so i need to query catalog to get  definition of
thetable.<br />      on the basis of this definition i can create external table .<br /> eg: i am looking for some
thinglike :<br /><br />    select * from pg_catalog where table_name='
srikanth_ext_parallel_crt_sms_logs_child_depth_1_d_2008_03_30_daily' ;<br /><br /> 3) once i get the definition of the
table, i need to use that definition for creation of external table in a script which will run in cron job daily for
dataloading.<br /><br /> Can anyone guide/help me in this ?<br /><br /><br /><br /> Regards, <br /> Srikanth k Potluri
<br/> +63 9177444783(philippines) <br /> 

---

To: pgsql-admin@postgresql.org
Date: Wed, 9 Apr 2008 08:50:44 -0500
Subject: [ADMIN] How do i get DDL of a Table from system catalog ?
From: spotluri@ismartpanache.com

Hi,

How do i get DDL of a Table from system catalog ?

Purpose :
1) i need to create an external table on the basis of  another table.
     create table ext_table (like table_name); ------------------> this doesnot work for external tables.
 
try - create table ext_table (like pg_catalog.table_name); - it worked for me.
 
 

2)  so i need to query catalog to get  definition of the table.
     on the basis of this definition i can create external table .
eg: i am looking for some thing like :

   select * from pg_catalog where table_name=' srikanth_ext_parallel_crt_sms_logs_child_depth_1_d_2008_03_30_daily ' ;

3) once i get the definition of the table , i need to use that definition for creation of external table in a script which will run in cron job daily for data loading.

Can anyone guide/help me in this ?



Regards,
Srikanth k Potluri
+63 9177444783(philippines)