CODEWITHSUNDEEP
databasepostgresqlbackup
Zuckonit
Zuckonit

Reputation: 685

how to dump part of fields of a special table under postgresql 8.1

how to dump part of fields of a special table under postgresql 8.1. command 'pg_dump' ? or some commands else? could you please help with this. Thanks in advance!

Upvotes: 1

Views: 113

Answers (1)

Erwin Brandstetter
Erwin Brandstetter

Reputation: 658672

Use COPY.

With your ancient Postgres 8.1 you can't use a VIEW or a SELECT. But you can specify columns to export.

COPY in modern Postgres can do a lot more.

You really should be upgrading to a current version. Postgres 8.1 has been unsupported since 2010.

Upvotes: 2

Related Questions