Creating, Importing, and Exporting Data
The tables that you create with PCC are initially empty. You can add data to them through PCC or by importing data. PCC provides a wizard to export data and one to import data.
Creating Data Through PCC
See To add rows of data to the Grid.
Importing Data with Bulk Data Utility
See bdu in PSQL User's Guide.
Importing Data with Import Data Wizard
The Import Data Wizard reads delimited data from a text file and adds the data to a table. The wizard allows you to specify the following:
•
Text file that contains the data to import.
•
Field delimiter.
•
Encoding of the imported data. The encoding must match the encoding that was used to export the data. See Exporting Data with Export Data Wizard.
•
Whether or not the first line of the exported data contains the column names. If the data was exported with column names as the first line, it be must imported the same way.
Restrictions
The data must use a field delimiter of the comma, colon, or tab character. A combination of carriage return and line feed must delimit records.
►
To import data into a database table
1
For a particular database, right-click a table name under the Tables node.
This is the table into which you want to import the data. If you are interested in system tables, expand the Tables node under System Objects.
2
Click Import Data.
3
Provide the import characteristics as discussed above, then click Finish.
Exporting Data with Export Data Wizard
The Export Data Wizard exports data from a table to a text file. A combination of carriage return and line feed delimits records.
The wizard lets you specify the following:
•
Name of the file to which the data is exported. If you include a path with the file name, the directory or directories in the path must already exist.
•
SQL statement on which the export is based. For example, SELECT * FROM t1 would export all records from table t1.
•
Field delimiter (character used to separate data items in each record).
•
Encoding of the exported data. For example, if you select ISO-8859-1, the data is exported using that code page. The encoding choices are obtained from the machine on which the utility is running.
•
Whether or not to write the names of the columns as the first line of the exported data.
►
To export data from a database table
1
For a particular database, right-click a table name under the Tables node.
If you are interested in system tables, expand the Tables node under System Objects.
2
Click Export Data.
3
Provide the export characteristics as discussed above then, click Finish.