How can we export the data structre with seleted data in PostgreSQL?

Asked Jan 23 '14 at 05:38

Active Oct 07 '18 at 21:33

Viewed 57 times

I am working on the PostgreSQL 9.1.4, I have to export the Data structure with 1 row data.

But PostgreSql have options of "Data only or Structure only or Structure and data".

But my aim is to export the "Datastructre with 1 row data" .

How can achieve this in PostgeSQL9.1.4?

edited Oct 07 '18 at 21:33

S-Man

asked Jan 23 '14 at 05:38

Kanchetianeel

Are you saying your table has multiple rows of data and you only want to export one of those rows? – nullability Jan 23 '14 at 05:45
That's a bizarre requirement, and not easily satisifed due to referential integrity requirements, etc. I'd probably do an SQL format schema-and-data dump then hand-edit out most of the data from the dump text. – Craig Ringer Jan 23 '14 at 05:48
Thank you, I wish to export the default entry which id is -1. – Kanchetianeel Jan 23 '14 at 05:49
Yes, I have to export the single row with Data Structure. – Kanchetianeel Jan 23 '14 at 07:20

0 Answers0