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

4
Cloudranger 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

0
Thang Luu Quoc On

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

3
Veera 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
3
Narine Hayrapetyan On

to download the general database to .sql

and click "Start"