1 question about psql table

[Nina]

Hi all,

I am new here and also new for using psql, I hope I joined the correct
google group to ask question ;-)
Here we go~

I create one table:

CREATE TABLE positions (
id serial NOT NULL,
name integer
)

Then I type:

\d++

then it shows:

public | positions | table | database1 |
public | positions_id_seq | sequence | database1 |

MY Question is:
which command in psql will only give me output:
public | positions | table | database1 |

Because I don't want :
public | positions_id_seq | sequence | database1 |

Thanks~

[David Portas]

Nina wrote:

Hi all,

I am new here and also new for using psql, I hope I joined the correct
google group to ask question ;-)
Here we go~

I create one table:

CREATE TABLE positions (
id serial NOT NULL,
name integer
)

Then I type:

\d++

then it shows:

public | positions | table | database1 |
public | positions_id_seq | sequence | database1 |

MY Question is:
which command in psql will only give me output:
public | positions | table | database1 |

Because I don't want :
public | positions_id_seq | sequence | database1 |

Thanks~

Wrong forum. This is a Microsoft SQL Server group.

--
David Portas
SQL Server MVP
--

[Nina]

David Portas wrote:

Nina wrote:

Hi all,

I am new here and also new for using psql, I hope I joined the correct
google group to ask question ;-)
Here we go~

I create one table:

CREATE TABLE positions (
id serial NOT NULL,
name integer
)

Then I type:

\d++

then it shows:

public | positions | table | database1 |
public | positions_id_seq | sequence | database1 |

MY Question is:
which command in psql will only give me output:
public | positions | table | database1 |

Because I don't want :
public | positions_id_seq | sequence | database1 |

Thanks~
Wrong forum. This is a Microsoft SQL Server group.

Oh, no! Really!

Anyway, Thanks David.

--
David Portas
SQL Server MVP
--