Skip to content

SQLite configuration file

January 20, 2010

I just created a simple configuration file for SQLite. It’s in my home directory, and is called .sqliterc. It contains the following lines:

# SQLite configuration file
.echo ON  # repeat every command
.header ON  # print column names
.separator "\t"  # change default separator to tab
.nullvalue "Null" # print the word "Null" rather than having empty fields

Now, every time I start SQLite, these commands will be run.

* Thanks to Kurt, who showed me how to do this!

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: