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)
Exclusive Marriage Proposals! Find UR life partner at Shaadi.com Try it!