Search Postgresql Archives

table dump function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I need a pl/pgsql function that will dump a table ddl  so I can export the definition to a file  before I drop the object.

 

the psql \d command won’t work, since it doesn’t dump the table ddl, it just lists the table’s attributes and indexes.

 

I’ve got the function mostly working,  but need help translating the ACL list into the grant commands.

 

Are there any standard PG functions that would be useful  for creating the grants?

 

Thanks in advance.

 

 

Doug Little

 

Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@xxxxxxxxxx

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux