Database Reference
In-Depth Information
Figure 4-8. Granting default privileges
When setting privileges for a schema, make sure to also set the usage privilege on the
schema to the groups you will be giving access to.
Import and Export
Like psql, pgAdmin allows you to import and export text files.
Importing files
The import feature is really a wrapper around the psql
\copy
command and requires
the table that will receive the data to exist already. In order to import data, right-click
the table you want to import data to, as shown in
Figure 4-9
.
