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
The law on personal data and social network?
What is the cost of a working hour of a designer?
The server for multiplayer games?
How to get weather data?
How to choose the CRUD operations for a db standard RBAC in YII2?
How to catch Exception?
How to do the tracing of Avatars on the forum ipb 3.4.7?
How to sync data?
More answers about
"How to create a dump of the PostgreSQL database tables?"
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.
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
Conduct a session of fortune-telling by the name the user has rights to look at the system table should not be:)
commented on July 8th 19 at 16:44
July 8th 19 at 16:40
su - postgres pg_dump -t table_name
to write your answer or comment.
Find more questions by tags