| From: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
|---|---|
| To: | "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | table dump function |
| Date: | 2013-03-07 15:58:25 |
| Message-ID: | 8585BA53443004458E0BAA6134C5A7FBB6BEAFA7@EGEXCMB01.oww.root.lcl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
[cid:image001(dot)jpg(at)01CE1B1A(dot)4F4C8E80] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-03-07 16:05:13 | Re: table dump function |
| Previous Message | Eduardo Morras | 2013-03-07 14:50:58 | Re: Gitorious |