Sql

Search

psql show columns of table

SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';Code language: SQL (Structured Query Language) (sql)

Comment

view columns in table postgresql

d table_name

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to change mysql root password in windows 10
Sql :: mysql add fields
Sql :: calculate age in sql
Sql :: postgresql substring
Sql :: mysql jdbc timezone
Sql :: wordpress print query sql
Sql :: mysql sort by date column
Sql :: oracle undo usage by session
Sql :: job for postgresql.service failed because the control process exited with error code. see "systemctl status postgresql.service" and "journalctl -xe" for details.
Sql :: psql connect
Sql :: sql timestamp to date
Sql :: oracle tables with column name
Sql :: sql check if date is between 2 dates
Sql :: mssql find deadlocks
Sql :: select table column name in sql
Sql :: flask sqlalchemy default value
Sql :: sqlite3 show columns name
Sql :: restore postgres database from dump
Sql :: mysql select where starts with
Sql :: install postgresql centos 5
Sql :: mysql url
Sql :: execute stored procedure
Sql :: Alter table add column in SQL Server- NAYCode.com
Sql :: copy table postgres
Sql :: identify number of rows in sql
Sql :: check constraint in sql
Sql :: mysql delete all except
Sql :: date format in postgresql
Sql :: mysql clear screen
Sql :: sql blank vs null

Search

SQL

psql show columns of table

view columns in table postgresql

ADD CONTENT