To: [EMAIL PROTECTED]: Wed, 9 Apr 2008 08:50:44 -0500Subject: [ADMIN] How do i
get DDL of a Table from system catalog ?From: [EMAIL PROTECTED],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)
_________________________________________________________________
Technology : Catch up on updates on the latest Gadgets, Reviews, Gaming and
Tips to use technology etc.
http://computing.in.msn.com/
