A crash course in PostgreSQL, part 2

15.09.2011

testdb=# \copy comics TO '/home/carla/freakout1.txt'

You may use any of the COPY and \copy command options on exports, such as delimiters, just like when you copy data from a file into a table.

We could go on for ages on specific operations and commands, and that would be way fun. But even in online articles there are limits, and now you know enough to continue exploring different commands on your own such as updates, deletions, joins, how to handle nulls, finding specific records and fields, and so on. So now let's take a quick look at some key terminology.

Databases are chock-full of special terminology. Here are four terms you should know and understand, and in knowing, and understanding them, you'll be ahead of a lot of people who think they know databases.