On 25/10/12 19:45, Raymond O'Donnell wrote:
> On 25/10/2012 16:32, Linos wrote:
>> Hello,
>> there is some way to get and old integer primary key column to show the
>> "type"
>> serial at table description?
>>
>> I had a table like this:
>>
>> CREATE TABLE test
>> (
>> test_id integer NOT N
On 25/10/2012 16:32, Linos wrote:
> Hello,
> there is some way to get and old integer primary key column to show the
> "type"
> serial at table description?
>
> I had a table like this:
>
> CREATE TABLE test
> (
> test_id integer NOT NULL,
> CONSTRAINT test_pkey PRIMARY KEY (test_id),
On 25/10/12 17:39, Tom Lane wrote:
> Linos writes:
>> there is some way to get and old integer primary key column to show the
>> "type"
>> serial at table description?
>
> No, because there is no such type. "serial" is just a convenient macro
> that you can use in CREATE TABLE; it's not a
Linos writes:
> there is some way to get and old integer primary key column to show the
> "type"
> serial at table description?
No, because there is no such type. "serial" is just a convenient macro
that you can use in CREATE TABLE; it's not a real type.
regards,
Hello,
there is some way to get and old integer primary key column to show the
"type"
serial at table description?
I had a table like this:
CREATE TABLE test
(
test_id integer NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (test_id),
);
that i would like to see as:
CREATE TABLE test
(
