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

175.1k Views Asked by At

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

4

There are 4 best solutions below

3
On

to download the general database to .sql

and click "Start"

0
On

Click on Tables -> Views Tables -> Select All tables in right window Right click selection -> Generate SQL" -> DDL

3
On

I tried like this:

  • Doubleclick the table columns
  • Select all the columns
  • Choose right click the mouse and select copy advanced info
  • Open an Excel -> paste special -> choose text option
  • All your table data structure will be in the Excel sheet
4
On

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