QGIS comes with a plugin named SPIT (Shapefile to PostGIS Import Tool). SPIT can
be used to load multiple shapefiles at one time and includes support for schemas.
To use SPIT, open the Plugin Manager from the Plugins menu,
in the Installed menu check the box next to the
SPIT plugin
and click [OK]. The SPIT icon will be added to the plugin toolbar.
To import a shapefile, click on the SPIT tool in the toolbar
to open the SPIT - Shapefile to PostGIS Import Tool dialog. Select
the PostGIS database you want to connect to and click on [Connect]. If you
want, you can define or change some import options. Now you can add one or more
files to the queue by clicking on the [Add] button. To process the files,
click on the [OK] button. The progress of the import as well as any
errors/warnings will be displayed as each shapefile is processed.
Figure SPIT Plugin 1: