How to create a dump of the PostgreSQL database tables?

Need to do a table dump from a remote database server.
July 8th 19 at 16:36
2 answers
July 8th 19 at 16:38
pg_dump -t table_name
Thank you, it is written in the manual, but here's an example remotely necessary, and such command pg_dump -i-h dbxx -user_crm U-C-F p user_crm, gives pg_dump: SQL command failed and then pg_dump: Error message from server: ERROR: permission denied for relation pg_namespace, it is not clear or commands in the wrong order or something with the authentication. - Arely.Casper commented on July 8th 19 at 16:41
:
>> ERROR: permission denied for relation pg_namespace

The error suggests that your user user_crm no right even to read the signs pg_namespace.
Get two outputs
1). Queried this table from user with higher privileges
2). Give this user privileges to this table
https://www.postgresql.org/docs/9.4/static/sql-gra...

Conduct a session of fortune-telling by the name the user has rights to look at the system table should not be:) - herman.Labadie commented on July 8th 19 at 16:44
July 8th 19 at 16:40
https://wiki.postgresql.org/wiki/First_steps

su - postgres pg_dump -t table_name

Find more questions by tags PostgreSQL