---
title: "Discussion on \"postgreSQL\" | Hashnode"
description: "Discussion on \"postgreSQL\". psql -h localhost -d postgres\nCREATE TABLE subjects(id int GENERATED ALWAYS AS IDENTITY PRIMARY KEY,name varchar(20) NOT NULL);\nAlter table\nALTER TABLE subjectsADD COLUMN credits varchar(10) NOT NULL;\nALTER TABLE subjectsADD COLUMN credits INT;\nDrop ..."
url: "https://hashnode.com/posts/postgresql/677227abe4ddbf7fe65c1a0a"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [postgreSQL](https://uzma.hashnode.dev/postgresql?utm_source=hashnode&utm_medium=feed)

psql -h localhost -d postgres CREATE TABLE subjects(id int GENERATED ALWAYS AS IDENTITY PRIMARY KEY,name varchar(20) NOT NULL); Alter table ALTER TABLE subjectsADD COLUMN credits varchar(10) NOT NULL; ALTER TABLE subjectsADD COLUMN credits INT; Drop ...

Dec 30, 2024 · 1 min read · uzma.hashnode.dev  
Updated Jan 2, 2025  
Read the article

-   [#womenwhotech](https://hashnode.com/tag/womenwhotech)

## Written by

[Uzma](https://hashnode.com/@uzma2023)

@uzma2023

  
[View profile](https://hashnode.com/@uzma2023)

taking action.

Writing blogs on what i learnt so that i could refer them later :)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.