> I'm quite a new guy on the Linux World and I have a tremendous problem
> with ProstgreSQL, the problem is that after changing the name of the
> host (via Network Manager in KDE) and restarting the server, the
> PosgreSQL (and other things like XWindow) stopped working.
>
> I tried to restore th
> When I type less 20020422_project_summaries.gz, I get the
> text of the database of this file. So it seems that it's already unzipped
> but has the .gz extension. how do I import this file
> as a database into postgresql? I'm running cygwin and pgAdmin II
> on a win2k computer.
>
I am no
> How can I reset a sequence number back to 0 ?
>
SELECT setval('sequence_name', 0);
In order for this to work, the sequence must have been created with
a MINVALUE of 0 (the default MINVALUE is 1)
CREATE SEQUENCE sequence_name MINVALUE 0;
---(end of broadcast)---
On 30 Nov 2001 10:52:26 -0800, Tony Reina <[EMAIL PROTECTED]> wrote:
> I seem to remember a psql option that dumped out the table schema. I
> can't seem to find it in the man for psql. Could someone point out the
> option to me?
>
In psql \? is your friend.
Probably what you want is \d tableNam
>
> In order to maintain the database schema, I started out by using
> a script like this one which I kept stored in my source
> repository:
>
I do something similar: keep the source code for the database
schema in the cvs repository with my application code...
But I do not use a shell scr
On Tue, 16 Oct 2001 18:42:19 +0100, Allan Engelhardt <[EMAIL PROTECTED]> wrote:
> OK, I'm probably doing something very stupid, but can somebody explain how I'm
>supposed to restore a custom archive dump?
>
> $ createdb foo
> CREATE DATABASE
> $ psql foo
> foo=# create table users (id serial);
>
On Mon, 10 Sep 2001 01:25:59 + (UTC), Tim Boring <[EMAIL PROTECTED]>:
> Can you change a column modifier after you've created the table? For
> example, I have a table called "authors" with the following columns:
> authorid, authorfirstname, authorlastname, authormi, statecode, country,
> born
