you can retrieve it using the currentVal function on the
sequence used to generate that id.
"sebmil" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I have a table with two columns, created with : CREATE TABLE test ( id
> serial primary key, name text ) ;
>
> To populate
er by
the priority value instead.
So you might have a table like follows:
priorityvalue
1 3
2 1
3 2
--
Prasanth Kumar
[EMAIL PROTECTED]
tement for Postgres?
> Thank you
>
> Best Regards,
> Howard
> CIM/MASTEC
> Tel:(65)8605283
You can do '\dt' to list all tables. There is also a system table
'pg_tables' which you can use if you like to do a select instead. Do
SELECT tablename FROM pg_tables where tableowner='postgres';
--
Prasanth Kumar
[EMAIL PROTECTED]
"Michael Wagner" <[EMAIL PROTECTED]> writes:
> We need to export an SQL database to Excel. Is this within your scope and =
> what might your cost be?
>
> Please respond to Dan Beach
Why not just save it to text CSV format and Excel can then easily
import it
whether you can add a table associating "priority" with
> "address_type". If you can, you might try something like the following
> example, using the address_priority table:
> Appears to work with either Oracle or Postgres (though I changed VARCHAR
> to VARCH
limit 1 ;
>
> sure you can change the limit if you wish more addresses.
> hope that helps
> Omid Omoomi
>
> >From: [EMAIL PROTECTED] (Prasanth A. Kumar)
> >To: [EMAIL PROTECTED]
> >Subject: [SQL] Select by priority
> >Date: 15 Jul 2000 10:11:43 -0700
>
work address. Is it
within the realm of sql to be able to do that?
--
Prasanth Kumar
[EMAIL PROTECTED]
