Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DBeaver, export from database Postgres, table structure (properties) into file .txt

I have little problem with DBeaver. I want to export my structure from each table from database in file .txt. I found how to export all data but I don't need this data, just table structure. If you have some solutions for export table structure .csv it'll be good.

Here is a an image about structure of the table:

https://imgur.com/a/oTVMFhw

like image 231
Iani M.D. Avatar asked Jul 27 '18 07:07

Iani M.D.


People also ask

How do I export data from DBeaver to excel?

Select Window / Preferences / DBeaver / Editors / Data Editor / Lob Editors binary data formatter and select “Hex”. Right click on all of the results of the query. Note: For some tables where comma delimited is not useful (example inventory tables) just copy the results and paste into Excel. Select Export Data…


1 Answers

If you are happy to have the table structures as SQL CREATE statements, then you can just go to the navigator panel on the left, into "Tables", select all the tables, then right click and Choose "Generate SQL" -> DDL

like image 193
Cloudranger Avatar answered Sep 21 '22 06:09

Cloudranger