<HTML>
Hi,<br>
<br>
How do i get DDL of a Table from system catalog ?<br>
<br>
Purpose :<br>
1) i need to create an external table 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 the
table.<b=
r>
on the basis of this definition i can create external
t=
able .<br>
eg: i am looking for some thing like :<br>
<br>
select * from pg_catalog where table_name=3D'
srikanth_ext_par=
allel_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
f=
or creation of external table in a script which will run in cron job daily
=
for data loading.<br>
<br>
Can anyone guide/help me in this ?<br>
<br>
<br>
<br>
Regards,
<br>
Srikanth k Potluri
<br>
+63 9177444783(philippines) <BR></HTML>
