Re: [GENERAL] pg_get_serial_sequence and table inheritence

[Rafa Couto]

2005/5/31, Timothy Perrigo <[EMAIL PROTECTED]>:

> I'd like to be able to call pg_get_serial_sequence passing "derived"
> for the table and "id" for the sequence column (to get, in this case
> "base_id_seq").  If nothing like this currently exists, any
> suggestions on how I could write a plpgsql function to get this
> behavior?

  You have one sequence for every serial field in sequences (from psql: "\ds").
  

-- 
Rafa Couto (caligari)
mailto:[EMAIL PROTECTED]

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

RE: [GENERAL] Postgres 7.0.2 and ODBC

[Rafa Couto]

> Can I use ODBC driver for windows version 6.5 to connect to postgres
7.0.2?

Yes, you must (there is no ODBC driver version > 6.5 for win, I think)

[GENERAL] RE: Importing into Postgres from a csv file

[Rafa Couto]

- Mensaje original -
De: "Jake" <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviado: miércoles, 23 de agosto de 2000 21:56
Asunto: [GENERAL] Importing into Postgres from a csv file


> Does any one know if this is possible, and if so how?

Use copy command:

COPY table FROM 'data.csv'
USING DELIMITERS ','
WITH NULL AS 'null string'
  ;

RV: [GENERAL] Tables Question

[Rafa Couto]

> How can I retrieve the "names" of all the tables in my database ?

In Postgres 7:

>From psql: \dt
or \d for all objects

>From SQL:
select * from pg_tables where tablename not like 'pg_%';