![]() Postico supports CSV files with the most common column separator characters: comma (,), semicolon ( ), tab, or pipe (|) If your CSV file has a different encoding, use your favorite text editor to convert. (Except for the handling of empty strings, see below.) This is also the same format that the PostgreSQL command COPY (.) CSV HEADER uses. The default settings are such that a file exported from Postico with the "International" setting (see below) can be imported. Nevertheless, not all CSV files can be imported and in some cases you have to change the file's encoding. Since CSV files are not standardized, Postico is flexible and supports many configurations. If the button is disabled, make sure that least one column is selected to import. Once you've applied your settings, you can start the import procedure by clicking the "Import" button. If a problem is found, the import is aborted and changes are reverted. In this case, Postico checks the full file during import. ![]() If your CSV file is very large, Postico will only check the beginning of the file. Postico does not allow importing files with warnings. when trying to import textual data into a numeric column), ![]() When you select target columns, Postico checks the import file. If you choose "Do not import", Postico will ignore the column. Match and arrange source and target columns by selecting the destination from popup menu. If your target table hasn't been selected before, choose your target table from the popup button.Įach source column can be imported into one column of your target table. ![]() If your CSV file has a header, make sure the "First Row is Header" checkbox is enabled. If the content isn't diplayed properly, you have to adjust settings by changing the file's encoding, separator, quote and decimal character. Postico tries to load a preview of your file contents. If your file can't be selected, change its extension to ".csv". Go to "File" → "Import CSV…" or press ⌘-I and select a CSV file you'd like to import.Īlternatively, you can select "Import…" from the context menu by right-clicking on the table name in the left sidebar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |