Differences

This shows you the differences between two versions of the page.

--- howtos:sqlite_tutorial [2009/03/10 15:59] – Tidy up the highlighted paragraph xuesheng
+++ howtos:sqlite_tutorial [2013/10/25 14:52] (current) – external edit 127.0.0.1
@@ Line 339: / Line 339: @@
 <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>
@@ Line 346: / Line 346: @@
 </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>

POPFile - Automatic Email Classification

'sqlite' Tutorial for POPFile 0.21.0 to 1.0.1

Differences