This shows you the differences between two versions of the page.
howtos:sqlite_tutorial [2009/03/10 16:59] xuesheng Tidy up the highlighted paragraph |
howtos:sqlite_tutorial [2013/10/25 14:52] (current) xuesheng Stop the wiki making PostgreSQL into a broken link |
||
---|---|---|---|
Line 339: | Line 339: | ||
<code bash>$ zcat ex1.dump.gz | sqlite ex2</code> | <code bash>$ zcat ex1.dump.gz | sqlite ex2</code> | ||
- | The text format used is the same as used by PostgreSQL, so you can also use the **''.dump''** command to export an SQLite database into a PostgreSQL database. Like this: | + | The text format used is the same as used by %%PostgreSQL%%, so you can also use the **''.dump''** command to export an SQLite database into a %%PostgreSQL%% database. Like this: |
<code bash> | <code bash> | ||
Line 346: | Line 346: | ||
</code> | </code> | ||
- | You can almost (but not quite) go the other way and export a PostgreSQL database into SQLite using the **pg_dump** utility. Unfortunately, when **pg_dump** writes the database schema information, it uses some SQL syntax that SQLite does not understand. So you cannot pipe the output of **pg_dump** directly into **''sqlite''**. But if you can recreate the schema separately, you can use **pg_dump** with the **-a** option to list just the data of a PostgreSQL database and import that directly into SQLite. | + | You can almost (but not quite) go the other way and export a %%PostgreSQL%% database into SQLite using the **pg_dump** utility. Unfortunately, when **pg_dump** writes the database schema information, it uses some SQL syntax that SQLite does not understand. So you cannot pipe the output of **pg_dump** directly into **''sqlite''**. But if you can recreate the schema separately, you can use **pg_dump** with the **-a** option to list just the data of a %%PostgreSQL%% database and import that directly into SQLite. |
<code bash> | <code bash> |
Should you find anything in the documentation that is incomplete, unclear, outdated or just plain wrong, please let us know and leave a note in the Documentation Forum.