On Debian install PostgreSQL via APT. If you have APT installed:
1. Change to root.
2. Type apt-update.
3. Type apt-get install postgresql postgresql-client
#2 updates your APT package list to the lastest-and-greatest. #3 installed
the server and client applications.
I'd read up on APT at the De
A significant difference, and something that might be frustrating, is
listing databases and database objects and describing tables. To list
databases, type
\l
...and hit RETURN. To list tables in the database you've logged in to, type
\dt
If you've got some familiarity with MySQL then querying
Clients aside, and as Christopher wrote, there are lots of differences
between the two systems. PostgreSQL supports higher-end Enterprise-level
RDBMS features. MySQL tends to be quicker. For example, and as just one
example, PostgreSQL can store and handle GIS data through PostGIS. MySQL's
OGC-comp
First, makes sure the PostgreSQL database is listening for TCP/IP
connections on the computer you're trying to connect to. On Mac OS X, run
this command in the a terminal, i.e. Terminal.app:
netstat -l
You should see a line like this somewhere in the output:
tcp6 0 0 *.5432 *.* LISTEN
Second, t
Bob,
This command:
pg_dump aurel
...should output the structure and contents of your "aurel" database to
your screen SQL with comments.
What version of PostgreSQL are you running and on what operating system?
Jim
> No joy
>
> pg_dump aurel > aurel.out
>
> Returns -
> ERROR: syntax error at o
Sorry.
The command will output ... *AS* SQL with comments.
> Bob,
>
> This command:
>
> pg_dump aurel
>
> ...should output the structure and contents of your "aurel" database to
> your screen SQL with comments.
>
> What version of PostgreSQL are you running and on what operating system?
>
> Jim
>
