DDL create statement of HAWQ Table

[#1]

Hi,

Can anyone let me know how we can see DDL (Create Statement) of table in HAWQ.

Thanks,

Narendra

[#2]

Hi,

have you tried with

\d table_name

from the psql command line?

[#3]

Hi @Marco Gaido,

Yes.. but it will give basic table structure. Was there any way to see create statement with all other properties which it is holding.?

And, if possible can you help me with script to get all the table DDL's under schema in HAWQ.

Like we see in Hive -- show create table <<Table Name>>;??

[#4]

What you can do is:

- list all tables in schema

\dt YOUR_SCHEMA.*

- and then get the create table for each of them via:

\d+ table_name